Mysql内连接在Mysql 5.1上不起作用

Question

It works correctly on my local server (MySql 5.5) but it doesn't work on remote server (MySql 5.1)

$dati = mysql_query(" 
    SELECT      * 
    FROM        $tb_liguria 
    JOIN        $tb_piemonte ON $tb_piemonte.piemonte_data = $tb_liguria.liguria_data
    JOIN        $tb_paca ON $tb_paca.paca_data = $tb_liguria.liguria_data
    JOIN        $tb_rhonealpes ON $tb_rhonealpes.rhonealpes_data = $tb_liguria.liguria_data
    WHERE       $tb_liguria.liguria_data >= '$dataInizio' and $tb_liguria.liguria_data <= '$dataFine'
    ORDER       BY $tb_liguria.liguria_data 
");

I also tried this but nothing has changed

$dati = mysql_query(" 
    SELECT      * 
    FROM        $tb_liguria 
    JOIN        ($tb_piemonte, $tb_paca, $tb_rhonealpes)
    ON          ($tb_liguria.liguria_data=$tb_piemonte.piemonte_data AND $tb_liguria.liguria_data=$tb_paca.paca_data AND $tb_liguria.liguria_data=$tb_rhonealpes.rhonealpes_data)
    WHERE       ($tb_liguria.liguria_data >= '$dataInizio' AND $tb_liguria.liguria_data <= '$dataFine')
    ORDER BY    $tb_liguria.liguria_data 
");

Answer 1

SOLVED!

Adding this before the query:

$setupMySql = mysql_query(" SET OPTION SQL_BIG_SELECTS = 1 " ) or die(mysql_error());