Nested Query?

[ProgressiveJL]

Hi all,

I'm not sure if it's possible but I'd like to combine the follow two queries into one:

select substr(reserved, 11, 10) as employees, tdate from jobs union all select employee, tdate from items

select compname, storeid, address, city, state, country, pcode, telnum, faxnum from store

Is there a way I can nest the statements?

Thanks in advance!

 

[JRB-Bldr]

Perhaps you did not see my previous posting...
Nested Query - Syntax Problem
thread1252-1333865

If not, look at it and you can see my VFP7 nested query code (albeit it does not work - YET), and you can see the replies suggesting how I can make it work.

That should give you some ideas.

Good Luck,
JRB-Bldr