in method mysql joins evaluated?
i have following query:
select c.*
from companies c
join users u using(companyid)
join jobs j using(userid)
join useraccounts us using(userid)
where j.jobid = 123;
i have following questions:
- is controlling syntax synonymous syntax?
- are joins evaluated left right? words, does query say: x = companies join users; y = x join jobs; z = y join useraccounts;
- if answer doubt 2 yes, stable assume companies list companyid, userid jobid columns?
- i don't know where apportionment used collect rows companies list referring alias "j"
any assistance appreciated!
Comments
Post a Comment