Bill, 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. Steve -----Original Message----- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 9:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -INTERNAL ERROR- Out of dynamic space 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)
