[SELECT supplier_name,prp_id,prp_name,supplier_id FROM tbl_prp INNER JOIN tbl_supplier ON prp_supplier_id=supplier_id WHERE prp_inactive<>1 AND =1 ORDER BY supplier_name]Query failed: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 '=1 ORDER BY supplier_name' at line 1