List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 24 2000 11:48pm
Subject:Re: Zip codes...
View as plain text  
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
Thread
Zip codes...Roy Nasser25 Feb
  • Re: Zip codes...Dan Nelson25 Feb
    • RE: Zip codes...Roy Nasser25 Feb
      • Re: Zip codes...Dan Nelson25 Feb
        • RE: Zip codes...Roy Nasser25 Feb
          • Re: Zip codes...Dan Nelson25 Feb
            • RE: Zip codes...Roy Nasser25 Feb
              • Re: Zip codes...Benjamin Pflugmann25 Feb
    • Re: Zip codes...James Treworgy25 Feb
  • Re: Zip codes...Graeme B. Davis25 Feb
    • Re: Zip codes...James Treworgy25 Feb
      • Re: Zip codes...Robert Crawford25 Feb