In the last episode (Feb 24), Roy Nasser said:
> This is my total Query... for some reason it is giving me an error at the
> ABS( part...
>
> SELECT c.name as CinemaName, c.CinemaID, c.zip as zipcode, p.time, m.name as
> MovieName, m.MovieID, m.rating, m.duration FROM tbl_Movies as m, tbl_Playing
> as p, tbl_Cinemas as c WHERE c.CinemaID=p.CinemaID and p.MovieID=m.MovieID
> and p.time > '20:55:00' and p.start < '2000-02-24' and p.end > '2000-02-24'
> ORDER BY ABS(zipcode - 01450) p.CinemaID, p.MovieID, p.time ASC;
At the abs part, or the p.CinemaID part? You need a comma between
them. What is the exact error text?
--
Dan Nelson
dnelson@stripped
