A
aannyy
Guest
I'm new to MySQL. I'm using MySQL 3.23.51 Have a simple question:how to find a data from one table which is not in another table. for example I'm writing next statement:
SELECT * FROM table1 WHERE data1 NOT IN (SELECT data1 FROM table2)
when exwcutin it I get error:
"You have an error in your SQL syntax near 'select room_nbr from kc_ip_room)' at line 1"
What is the correct way of doing that in MySQL? Thanks a lot.
SELECT * FROM table1 WHERE data1 NOT IN (SELECT data1 FROM table2)
when exwcutin it I get error:
"You have an error in your SQL syntax near 'select room_nbr from kc_ip_room)' at line 1"
What is the correct way of doing that in MySQL? Thanks a lot.