-- Rows with ID existing in both a, b and c -- JOIN is equivalent to INNER JOIN SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a JOIN table2 b ON a.ID = b.ID JOIN table3 c ON a.ID = c.ID WHERE a.ID >= 1000; -- ⇓ Test it ⇓ (Fiddle source link)
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter