joins in sql - Google Search

PHOTO EMBED

Tue Feb 01 2022 19:44:50 GMT+0000 (UTC)

Saved by @ask4med #sql

-- 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)
content_copyCOPY

https://www.google.com/search?q