WTH is wrong with this MySql statement? - GoFuckYourself.com

alex79 · 10-18-2006, 10:14 AM

Code:

SELECT id FROM `table1` WHERE id NOT IN ( SELECT id FROM `table2` )

i get an #1064 - You have an error in your SQL syntax near 'SELECT id FROM `table1` error message

FuqALot · 10-18-2006, 10:28 AM

try `table1` without quotes, and `table2` without quotes too.

and fyi, u need a pretty new mysql version to use query with query.. but first u should try without the quote.

psili · 10-18-2006, 10:32 AM

You could try:

SELECT id FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL

CaptainHowdy · 10-18-2006, 10:37 AM

Quote:

Originally Posted by psili

You could try:

SELECT id FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL

!!

10-18-2006, 10:32 AM	#3
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	You could try: SELECT id FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL __________________ Your post count means nothing.

10-18-2006, 10:14 AM	#1
alex79 Confirmed User Join Date: Jun 2002 Location: france Posts: 996	WTH is wrong with this MySql statement? Code: SELECT id FROM `table1` WHERE id NOT IN ( SELECT id FROM `table2` ) i get an #1064 - You have an error in your SQL syntax near 'SELECT id FROM `table1` error message __________________

10-18-2006, 10:28 AM	#2
FuqALot Confirmed User Join Date: Dec 2001 Location: Malibu Posts: 3,817	try `table1` without quotes, and `table2` without quotes too. and fyi, u need a pretty new mysql version to use query with query.. but first u should try without the quote.