Is there a way in SQL without resorting to subqueries to select a table, then
save the resulting field,
Then use that list for a future SQL query?
ex. select customerid from invoicefile;
save the list of customerid for later use
<later>
get that list of customerid
select cust.name , cust.addr , cust.city, etc from customerfile where
cust.id=(list of customerid) and cust.st='ny'
Or is this one of those pick "ain't it great we can do this" features?
George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
[email protected]
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
