JOIN vs INNER JOIN
Posted: Mon May 09, 2005 8:39 am
Hi all,
Just a quick question regarding the JOIN and INNER JOIN used in queries with mySQL.
Has there been some kind of change in the way queries must be structured or something just recently. Or perhaps it is a configuration issue.
Anyhow, I'm wondering why the following query:
... gives me an error, until I modify it to read:
This is just a recent thing. I upgraded my server system and so have re-installed mysql / PHP / apache, and suddenly pretty much all of my queries which were joined with a straight JOIN are now broken unless I go through and change them to INNER JOIN.
Can anyone shed any light on this?
Cheers.
Just a quick question regarding the JOIN and INNER JOIN used in queries with mySQL.
Has there been some kind of change in the way queries must be structured or something just recently. Or perhaps it is a configuration issue.
Anyhow, I'm wondering why the following query:
Code: Select all
SELECT `tbl_user_address`.`UA_PK`, `tbl_user_address`.`Title` FROM `tbl_user_address` JOIN `tbl_master_postcodes` ON (`tbl_user_address`.`Locale` = `tbl_master_postcodes`.`MPC_PK`) WHERE (`tbl_user_address`.`USER_ID` = '25') ORDER BY `tbl_user_address`.`Default` DESC, `tbl_user_address`.`Title`Code: Select all
SELECT `tbl_user_address`.`UA_PK`, `tbl_user_address`.`Title` FROM `tbl_user_address` INNER JOIN `tbl_master_postcodes` ON (`tbl_user_address`.`Locale` = `tbl_master_postcodes`.`MPC_PK`) WHERE (`tbl_user_address`.`USER_ID` = '25') ORDER BY `tbl_user_address`.`Default` DESC, `tbl_user_address`.`Title`Can anyone shed any light on this?
Cheers.