I am using version 3.23.58 and need to do the following:
select * from a where id not in (select tbl_id from b where tbl="a");
Given that my version does not support sub selects, how can I re-write the statement to get the desired results?
http://www.mysql.com/doc/en/Rewriting_subqueries.html
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]