ROTECTED]]
Sent: 16. juni 2002 18:15
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Nested queries and joins
SELECT ad_catego.* FROM ad_catego, db_subcategory
WHERE ad_catego.db_subcategory=rules.db_subcategory
AND rules.db_category != '2'
AND rules.db_login !='$session_login&
002 00:12
To: [EMAIL PROTECTED]
Subject: Nested queries and joins
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
Hello,
I have the following nested query that I would like to port to Mysql:
SELECT * FROM ad_catego
WHERE db_subcategory NOT IN
(SELECT rules.db_subcategory FROM rules
WHERE rules.db_login='$session_login')
AND db_category_int =2