Neil Tompkins wrote:
Using this query seems to hang my computer and mySQL server reported the
queries had been LOCKED.
How many records are in each table?
It could take a while, especially if you don't have indexes on the join
fields.
--
MySQL General Mailing List
For list archives: http:/
Using this query seems to hang my computer and mySQL server reported the
queries had been LOCKED.
> Date: Mon, 21 Aug 2006 11:09:35 +0200> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Return list where no data
> exists> >
Hi Neil,
what you need is a LEFT JOIN:
SELECT a.*
FROM TableA a
LEFT JOIN TableB b ON a.ID = b.ID (assuming ID is what you relate the
tables on )
WHERE b.ID IS NULL;
should hopefully do what you want.
/Johan
Neil Tompkins skrev:
Hi,
I've two tables. What q