johnf wrote:
On Saturday 22 April 2006 11:01, Jon Foster wrote:
Try using
sqlquery1.TEXT:='SELECT organizations.name as org,
tests.name as test FROM tests, organizations WHERE
tests.organization=organizations.id AND result<>' + Quotedstr('PASS') +
'ORDER BY tests.name';
Is 'result' in only one of the tables?
John
I had tried that and it worked. Yes, 'result' is in only one table.
THX - Jon
--
Jon Foster
JF Possibilities, Inc.
[EMAIL PROTECTED]
541-410-2760
Making computers work for you!
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
