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

0 vote187 views1 answer
Sql put two columns into one
SQL
0 vote168 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote240 views2 answers
Getting customers with no orders sql
SQL
1 vote198 views4 answers
How to check table in postgresql from terminal
SQL
3 votes230 views3 answers
List columns in table postgres
SQL
1 vote198 views1 answer
Sql and
SQL
0 vote176 views1 answer
Ansi sql count duplicate rows
SQL
18 votes172 views4 answers
Mysql current date between two dates
SQL
10 votes177 views5 answers
Between keyword in sql
SQL
0 vote178 views1 answer
Get rows from 1 table with other table empty mysql
SQL