MySQL / PHPMYADMIN Help

mattmcb · #1 (**permalink**) 08-27-04, 11:23

Does anyone know why when I try and run this query in PHPMYADMIN:

Code:

SELECT  * 
FROM products_to_categories
WHERE products_id NOT 
IN (SELECT products_id
FROM products)

I get this error:

Quote:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT products_id
FROM products ) LIMIT 0, 30' at line 5

anacedent · #2 (**permalink**) 08-27-04, 17:16

Prior to V4.1 MySQL subselects are not supported

Internet Services

Web Development

Digital Marketing

Consumer Tech