That should be pretty straightforward in U2 SQL - I'd probably put a DISTINCT clause in - otherwise you'll probably get repeating customer records:
SELECT DISTINCT customerid FROM invoicefile TO SLIST 9; SELECT cust.name , cust.addr , cust.city, etc FROM customerfile SLIST 9 WHERE cust.st='ny'; Stuart Boydell -----Original Message----- 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? _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
