Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
I have problem wtih make left join query in tow big table
the first one have more then 10,000 records
and second table have more then 35000 records
i make query below:
SELECT table1.code, table1.siteaddress, table1.plateno, table2.plateno FROM table1 JOIN table2 ON table1.plateno=table2.plateno LIMIT 1,10;
that query retrieve a good result but it's took long time to do that
and in my php interface i lost connection with server and also the result.
any one can help me.
NOTE: sorry my English is weak