[PHP] Joining a number of tables in a MySQL query

Hello, I'm trying to relate four tables within a single query and am running into difficulties. Heck, I don't even know if it is possible. Most of the explainations I see are for two tables, not four... So I'm trying to do something like this: SELECT address.city, address.state,

Re: [PHP] Joining a number of tables in a MySQL query

SELECT WLPaddress.city, WLPaddress.state, WLPbib.publisher, WLPbib.title, WLPbib.publicationDate, WLPprofile.firstName, WLPprofile.lastName, WLPprofile.organization, WLPcountry.languageName FROM WLPbib LEFT JOIN WLPprofile ON WLPprofile.profileID = WLPbib.profileID LEFT JOIN