neiet mysql vaicaajums

[spa]

Sveicinaati speci!

Probleema sekojosha man uz MySQL 3.23.49 neiet shis konkreetais vaicaajums:

"SELECT * FROM table WHERE ID NOT IN (SELECT t1_ID From table1) LIMIT 1"

nevaru iebraukt kaadeelj, tjipa errors

MySQL said:

 

You have an error in your SQL syntax near 'SELECT t1_ID From table1) LIMIT 1' at line 1

[Delfins]

tāpēc ka JĀLASA MANUĀLIS... sub-queries nav mysql 3.x/4.x versijās

[spa]

Paldies Delfins par ievirziishanu pareizajaas sliedees.

Ar Join viss aizgaaja.

Vaicaajums sekojosh:SELECT table.* FROM table LEFT JOIN table1 ON table.id=table1.id

WHERE table1.id IS NULL LIMIT 1;