http://www.sqlite.org/lang_select.html
Lee Crain wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------