Hello everyone,
I'm using MYSQL Server version: 4.1.14 and I'm trying to execute a query that has more than 4 tables. The purpose is to produce a mailing list and download it into excel. The excel part is fine. But for some reason, I can't go beyond 3 tables in the code below;
===============================
$result=mysql_query("select * from name left join position ON name.id=position.id left join address ON position.id=address.id left join company ON address.id=company.id");
================================
If I do another LEFT JOIN, the query comes up blank and no data appears in the excel spreadsheet.
I'm trying to add the following;
LEFT JOIN email_address ON address.id=email_address.id
Any assistance would be appreciated.
Chelsea
I'm using MYSQL Server version: 4.1.14 and I'm trying to execute a query that has more than 4 tables. The purpose is to produce a mailing list and download it into excel. The excel part is fine. But for some reason, I can't go beyond 3 tables in the code below;
===============================
$result=mysql_query("select * from name left join position ON name.id=position.id left join address ON position.id=address.id left join company ON address.id=company.id");
================================
If I do another LEFT JOIN, the query comes up blank and no data appears in the excel spreadsheet.
I'm trying to add the following;
LEFT JOIN email_address ON address.id=email_address.id
Any assistance would be appreciated.
Chelsea