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 ...