spa Posted July 7, 2006 Report Share Posted July 7, 2006 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 Link to comment Share on other sites More sharing options...
Delfins Posted July 7, 2006 Report Share Posted July 7, 2006 tāpēc ka JĀLASA MANUĀLIS... sub-queries nav mysql 3.x/4.x versijās Link to comment Share on other sites More sharing options...
spa Posted July 7, 2006 Author Report Share Posted July 7, 2006 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; Link to comment Share on other sites More sharing options...
Recommended Posts