> OK. I guess that's what I was asking.
Yep, my guess is what Twenty Queries was doing was running the first. It
simply opens the query with what you have given it so nothing special runs
in the background there.
> So...Can I do
>
> SELECT (blah, blah) into MEMORY t1
>
> followed by
>
> SELECT (blah, blah)
> JOIN MEMORY t1 on d.LogCode = t1.LogCode
No - take a look at UNION. This will be able to do what you are after. Then
both queries will be run in the same go but produce a result that combines
the results.
> Do I have to tidy up the Memory table when I've finished? and how?
You won't have to use a memory table then, but if you do, simply closing
the query will clean up the memory table.
Steve Peacocke
Lecturer, NZ Diploma in Business
Lecturer, Batchelor of Computing Systems
Waiariki Institute of Technology
---------------------------------------------------------------------------
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"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/