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

3 votes230 views4 answers
Mysql create table from select statement
SQL
16 votes241 views2 answers
Sql exists
SQL
0 vote227 views1 answer
Oracle procedure chain step
SQL
3 votes236 views1 answer
Apex set debug level
SQL
0 vote253 views1 answer
Doesn't have default value mysql
SQL
23 votes264 views5 answers
Sql substring
SQL
3 votes209 views3 answers
Print in pl sql
SQL
4 votes216 views2 answers
What is table in sql
SQL
0 vote237 views1 answer
Sqlite get date only
SQL
0 vote247 views1 answer
Raiserror with nowait
SQL