Steve, At the R> prompt, that would probably mean that you forgot a right parenthesis.
Do you have the SELECT sub-query all on a single line within the direct dbms? I think there was a problem with a CR/LF in the WHERE clause that had a sub-query. Bill On Tue, 18 Nov 2003 09:21:16 -0600, Fogelson, Steve wrote: >SELECT ALL FROM OptionValue1 WHERE OP_ID NOT IN (SELECT OP_ID FROM >ProductOptions)
