Tezread wrote:had a look at the left join syntax on mysql.com site and I was wondering in my case- which fields do i reference in the USING (fieldA, field😎 part- do I reference all the fields or just one?
Wich filed link your tabels, as I can see from your select
select * qualityadmin, WHERE
qualityadmin.nature_selfhelp = qualityuser.nature_selfhelp
the field nature_selfhelp is used to link your tables, so that's why I write your select like this:
select * FROM qualityadmin
LEFT JOIN qualityuser USING(nature_selfhelp)
Did u try the select I wrote?
USING() function, is used when the field have the same name in both tables, if the field that u want to link the tables is named diferent then u use ON, in your case u can use USING but u can use ON too, like this ...
select * FROM qualityadmin
LEFT JOIN qualityuser ON qualityadmin.nature_selfhelp = qualityuser.nature_selfhelp
