Thanks so much. I thought there had to be a way to do it but I was looking at it from the wrong side of the coin.
Your help is much appreciated. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 1:16 PM To: [EMAIL PROTECTED] Subject: RE: Columnname IN -- technique Ramsour Mike <[EMAIL PROTECTED]> wrote: You should be able to do it, try a select statement along the lines of: SELECT t1.heatnum,t1.coil_list,t2.grade,t2.pounds + FROM IN_TEST t1,RCTSVIEW t2 + WHERE t1.heatnum=t2.heatnum + AND t1.coil_list contains t2.coilnum >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. > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
