Rev cgi & mySQL (again)

Dave Cragg dave.cragg at lacscentre.co.uk
Fri Jan 2 21:24:59 EST 2009


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.')
)




More information about the Use-livecode mailing list