Re: EOAndQualifier order
Re: EOAndQualifier order
- Subject: Re: EOAndQualifier order
- From: Ken Anderson <email@hidden>
- Date: Thu, 12 Jul 2007 07:58:39 -0400
Actually, Sybase will accept the query. It allows group by on fields that are not in the select.On Jul 12, 2007, at 2:55 AM, Q wrote: This query is invalid, your database should reject it.
It should be:
SELECT departmentId FROM foo WHERE lastName='Smith' AND firstName='Bob' GROUP BY departmentId
which is the same as writing:
SELECT DISTINCT departmentId FROM foo WHERE lastName='Smith' AND firstName='Bob'
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden