[sqlite] UNION?

[Lee Crain]

The query at the bottom of this email is failing on the word "UNION". (The
query works correctly in MS SQL Server.)

I believe this is, unfortunately correct, since the SQLite documentation
does not mention the reserved word "UNION" in the set of supported and
recognized SQL words (http://www.sqlite.org/lang.html).

Is this correct? If so, is there another way to accomplish this query as a
single query?

Thanks,

Lee Crain

__________________________________________________________________


SELECT Items.items_idx, Items.name, Items.active FROM Items 

WHERE active = 'T' AND Items.items_idx IN

(SELECT related_item FROM RelatedItems WHERE RelatedItems.item = 1777

UNION

SELECT item FROM RelatedItems WHERE RelatedItems.related_item = 1777)

ORDER BY Items.name ASC;


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------