Greetings: Is there any way that I could have a column that contains a list of values that can be found in another table and have that column referenced as an IN (...) statement?
Example: Table IN_TEST columns ---------------------------------- HEATNUM TEXT 12 COIL_LIST NOTE (containing a list of up to 20 coil numbers that are contained in table RCTSVIEW) ----------------------------------- SELECT t1.heatnum,t1.coil_list,t2.grade,t2.pounds + FROM IN_TEST t1,RCTSVIEW t2 + WHERE t1.heatnum=t2.heatnum AND t2.coilnum IN (t1.coil_list) -- I've tried different approaches but none have worked. Thanks for any ideas. Mike Ramsour BTW I just tried the new (LISTOF(...)) command and it is S-O-O-O-O sweet. Thanks to Razzak and crew for all of their wonderful work.
