comp.lang.php archive
Re: Negative SQL Query
From: abighill <abighill@gmail.com>
Date: Sun Mar 05 2006 - 12:10:11 CET
Date: Sun Mar 05 2006 - 12:10:11 CET
I posted the same probelm on the PHP Freaks Forum and Barand kindly
solved the problem for me:
SELECT u.*
FROM fett_url u
LEFT JOIN fett_url_to_data d
ON d.url_id = u.url_id AND d.data_id = 2
WHERE d.url_id IS NULL
ORDER BY u.url_title
Thanks everyone!
See post here: http://www.phpfreaks.com/forums/index.php?showtopic=87476
Received on Mon May 1 02:27:45 2006