Try without DISTINCT
Regards, Stephen Markson ForenSys The Forensic Systems Group HYPERLINK "http://www.forensys.ca/"www.ForenSys.ca 416 512 6950 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Charles Parks Sent: May 15, 2008 10:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Select syntax When I try a select statement I get "-ERROR- INTERNAL ERROR - in sort processing (2290)". The syntax I'm using is select distinct keyword from vwDVDKeywords where parentkeyword = 'fantasy' and keyword not in (select keyword from vwDVDKeywords where parentkeyword = 'adventure') and keyword not in (select keyword from vwDVDKeywords where parentkeyword = 'comedydrama') union select ChildKeyword from vwDVDKeywords where parentkeyword = 'fantasy' The individual statements work select distinct keyword from vwDVDKeywords where parentkeyword = 'fantasy' and keyword not in (select keyword from vwDVDKeywords where parentkeyword = 'adventure') and keyword not in (select keyword from vwDVDKeywords where parentkeyword = 'comedydrama') and select ChildKeyword from vwDVDKeywords where parentkeyword = 'fantasy' Keyword and ChildKeyword have the same datatype. What would be the correct way to union the two commands? No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.16/1434 - Release Date: 15/05/2008 7:24 AM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.16/1434 - Release Date: 15/05/2008 7:24 AM
