/ Published in: MySQL
URL: http://www.wellho.net/solutions/mysql-left-joins-to-link-three-or-more-tables.html
Expand |
Embed | Plain Text
SELECT * FROM (bdg LEFT JOIN res on bdg.bid = res.bid) LEFT JOIN dom on res.rid = dom.rid WHERE dom.rid IS NULL;
You need to login to post a comment.
