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.