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 ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users