[RBASE-L] - Select syntax

[Charles Parks]

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?