Sql inner join

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

Source: sqlfiddle.com

Sql inner join

SELECT   field1, CASE field2
         WHEN condition1 THEN 'result1'
         WHEN condition2 THEN 'result2'
         ELSE 'result'
      END, field3
FROM table_name;

Similar codes

2 votes175 views2 answers
Compare date mysql
SQL
9 votes208 views4 answers
Last mysql
SQL
0 vote249 views1 answer
Oracle sqlp update amount / quantity
SQL
1 vote141 views1 answer
Python escape string for sql
SQL
0 vote204 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
4 votes188 views1 answer
Mysql ip address
SQL
0 vote174 views1 answer
Sql gather statistics to increase performance
SQL
6 votes235 views2 answers
How to get last element sql
SQL
0 vote239 views1 answer
Mysql default uuid
SQL
0 vote151 views1 answer
Mariadb list tables
SQL