I still get the error "-ERROR- INTERNAL ERROR - in sort processing (2290)" with the revised syntax of select 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'
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Markson Posted At: Thursday, May 15, 2008 9:58 AM Posted To: RB7-L Conversation: [RBASE-L] - RE: Select syntax Subject: [RBASE-L] - RE: Select syntax Try without DISTINCT Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForenSys.ca <http://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 --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
