While executing JOIN SQL query in live server, i got the following error.
[code]
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay:
[/code]
To resolve this error, I have used the following SQL query before executing the JOIN SQL query.
[sql]
SET OPTION SQL_BIG_SELECTS=1;
[/sql]