Hi, will anyone help this statement gives me an error:
SELECT
`tbl_address_ou t_new`.`Locatio n_Name_IA`, `tbl_address_ou t_new`.`AMC_ID_ IA`,
COUNT(`Location _Name_IA`), COUNT(`AMC_ID_I A`)
WHERE `tbl_address_ou t_new`.`Locatio n_Name_IA` is not null
GROUP BY `tbl_address_ou t_new`.`Locatio n_Name_IA`, `tbl_address_ou t_new`.`AMC_ID_ IA` DESC;
and here's the error :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `tbl_address_ou t_new`.`Locatio n_Name_IA` is not null
GROUP BY `tbl_addres' at line 4
SELECT
`tbl_address_ou t_new`.`Locatio n_Name_IA`, `tbl_address_ou t_new`.`AMC_ID_ IA`,
COUNT(`Location _Name_IA`), COUNT(`AMC_ID_I A`)
WHERE `tbl_address_ou t_new`.`Locatio n_Name_IA` is not null
GROUP BY `tbl_address_ou t_new`.`Locatio n_Name_IA`, `tbl_address_ou t_new`.`AMC_ID_ IA` DESC;
and here's the error :
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `tbl_address_ou t_new`.`Locatio n_Name_IA` is not null
GROUP BY `tbl_addres' at line 4
Comment