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 vote249 views1 answer
Mysql c commands
SQL
1 vote201 views1 answer
Sql restore backup query
SQL
0 vote214 views1 answer
Sql server concat null
SQL
0 vote228 views1 answer
Oracle step procedure
SQL
1 vote219 views2 answers
This month mysql where
SQL
1 vote216 views1 answer
Mysql add fields
SQL
0 vote259 views1 answer
000webhost database values insert
SQL
0 vote203 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote298 views1 answer
Add computed column to table sql server
SQL
0 vote205 views1 answer
Ansi sql count duplicate rows
SQL