Re: Problems with alias names in WHERE clause

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 10, 2002 23:25, Zak Greant wrote: > On September 10, 2002 22:32, Paul DuBois wrote: > ... > > > You can't refer to aliases in WHERE clauses. Aliases refer to columns > > that have been selected, WHERE clauses determine which columns sho

Re: Problems with alias names in WHERE clause

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 10, 2002 22:32, Paul DuBois wrote: ... > You can't refer to aliases in WHERE clauses. Aliases refer to columns > that have been selected, WHERE clauses determine which columns should > be selected. In essence, WHERE refers to "input" c

Re: Problems with alias names in WHERE clause

At 20:57 -0700 9/10/02, Nicholas Berry wrote: >I search high and low for an explanation of this at >http://www.mysql.com/doc (hoping I didn't overlook anything) thought it >might be easier to ask this list to see if I'm the only one with this >problem. > >With the query statement - > SELECT i.id

Problems with alias names in WHERE clause

I search high and low for an explanation of this at http://www.mysql.com/doc (hoping I didn't overlook anything) thought it might be easier to ask this list to see if I'm the only one with this problem. With the query statement - SELECT i.id image_id, ifnull(i.photographer,"6") photo_id, ifnull