I'm not too sure about Locak SQL, but you usually do nested queries using
in, or exists.
eg.
select name from people
where company in (select company from companies where city = 'Auckland')
Another option is to create a temporary table, and then join to it.
eg.
Create your temporary table.
insert into company_temp
select company from companies
where city = 'Auckland'
select name from people, company_temp
where people.name = company_temp.name
Stacey
> -----Original Message-----
> From: Peter Vroegop [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 1 February 2001 11:21 a.m.
> To: Multiple recipients of list delphi
> Subject: [DUG]: Newbie SQL question
>
>
> Is it possible to do a query on the result set of a previous
> query. If so, how do you go about it?
>
> (Using D3 and Local SQL)
>
> Peter Vroegop
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
