On Mon, 2005-07-25 at 19:08 -0300, Marc G. Fournier wrote: > > On Mon, 25 Jul 2005, Jeffrey W. Baker wrote: > > > On Mon, 2005-07-25 at 18:11 -0300, Marc G. Fournier wrote: > >> Just curious as to whether or not a warning or something should be issued > >> in a case like: > >> > >> SELECT c.* > >> FROM company c, company_summary cs > >> WHERE c.id = cs.id > >> AND cs.detail = 'test' > >> ORDER BY cs.fullname; > > > > Seems like it should work. Is it not returning in fullname order in > > your tests? > > Full name isn't a field in the results, so how would it be ORDERing based > on it? fullname is a field in the table being joined in order to restrict > the results to just those with cs.detail = 'test' ... but company itself > doesn't have a field fullname ...
I'm still not seeing the problem. cs.fullname is in the product of the join, and you can order the result thereby, and not return the column. -jwb ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly