What is the data type of Op_ID? Is there any chance that the data contains a comma, parenthesis, or quotation mark?
Try correlating the sub-query: SELECT ALL FROM optionvalue1 v1 + WHERE op_id NOT in + (sel op_id from productOptions p2 where p2.op_id = v1.op_id) Bill On Tue, 18 Nov 2003 09:58:14 -0600, Fogelson, Steve wrote: >Thanks for the response. I am performing this at an R> prompt. >It wraps around like this: >R>SELECT ALL FROM OptionValue1 WHERE OP_ID NOT IN (SELECT OP_ID FROM >ProductO+ >+>ptions) >So I believe the right parenthesis is there. I copy and pasted all the table >names and columns to make sure they were spelled correctly. >Still doesn't work.
