🚀 go-pugleaf

On Fri, 5 Jun 1998 14:33:40 -0700, "Jason Ortner" <jortner@onramp113.org>
wrote:

>I have a question regarding the way sql retrieves data.   I have a
>query I am using, that retrieves data, sometimes.  Does the order in
>which you have the select stmt. fields have anything to do with the
>way in which the data is retrieved?  If I ask for info.,using the
>"like" clause on one field where there is no data that matches, but I
>ask for other fields, in the same query,where there is data that
>matches it appears that if the first field doesn't match, the whole
>query is blank.  If anyone wants to see a copy of the query I will be
>glad to post it.  This makes no sense to me and the "Learn sql" disk
>doesn't seem to really cover the problem.  Any ideas.

The choice of which records to include in or exclude from the result set is
determined by conditions in the WHERE clause. The fields in the SELECT
clause of the statement should never affect this, regardless of their order
of appearance or whether they appear at all in the SELECT clause.

Post your actual SQL statement.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "Knowledge comes, but wisdom lingers."
Technical Publications                -- Alfred, Lord Tennyson (1809-1914)
INPRISE Corporation
http://www.inprise.com/delphi