Sorry, syntax error in my last post: Should be:
(
SELECT Col1, Col2, Col3, Col4
FROM myTable
WHERE Col1 IN ('toto','tiki','tata','etc.')
)
UNION DISTINCT
(
SELECT Col1, Col2, Col3, Col4
FROM myTable
WHERE Col2 IN ('toto','tiki','tata','etc.')
)
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
