Advanced Search

Left Joins to link three or more tables

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your 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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.