Yes both text 16 seems kinda wierd. Gives a "no rows exist or meet the where clause.' error Dick
Dennis McGrath asked ... Are the two text fields the same length i.e. TEXT (8) ??? Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Fey Sent: Wednesday, October 22, 2008 12:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Maybe its the weather... This works: Select StNumber from temp1 where StNumber = 'A1234' This works: Select StyleNum from VenPrice where StyleNum = 'A1234' This DOES NOT work: Select * from VenPrice where StyleNum in (select StNumber from temp1) What am I missing?
