davewatts

The first table with less rows is the best option. However, it is important to have indexes applied to the rows that you intend to join or search on. It is possible to retrieve data from a table of 5,000,000 records that is index correctly faster than a table with 500,000 that isn\'t indexed correctly.

This is my first time on the forum and I\'m looking for some kind person to help me. I have developed some SQL that works in both MS SQL Server and in Sybase. This code has been migrated to run on Mysql and it fails a syntax check. I have had a look at the manual as regards the syntax for the UPDATE statement and it would appear that you cannot have a FROM clause joining two table. Could you let me know if this is true or if there is a method of how to achieve this without using a from clause. update player set POINTS = 3 FROM Player AS PP, Matches AS M WHERE M.GAMEID = PP.GAMEID and M.MATCHID = PP.MATCHID and M.RESULTIND = PP.RESULTIND and PP.IND = \'N\'