Posted By

karmacode on 12/03/09


Tagged


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

4rp70x1n
dantreacy
jackkeller


Left Joins to link three or more tables


 / Published in: MySQL
 

URL: http://www.wellho.net/solutions/mysql-left-joins-to-link-three-or-more-tables.html

  1. SELECT * FROM (bdg LEFT JOIN res on bdg.bid = res.bid) LEFT JOIN dom on res.rid = dom.rid WHERE dom.rid IS NULL;

Report this snippet  

You need to login to post a comment.