two JOINS

admin

Administrator
Staff member
hello,

i am using LEFT JOIN between two tables [domains, domains_pictures]:

domains LEFT JOIN domains_pics ON domains.id=domains_pics.id_domain

----

however i need to use 2 joins at the same time, both from the DOMAINS table, something like this:

domains LEFT JOIN domains_pics ON domains.id=domains_pics.id_domain
+
domains LEFT JOIN domains_guestbook ON domains.id=domains_guestbook.id_domain

----

but it isnt working... working weird. is this supported by mysql?
 
Back
Top