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

1 vote132 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote175 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
4 votes156 views3 answers
NOT NULL SQL
SQL
9 votes142 views3 answers
Find all tables with column name
SQL
0 vote139 views1 answer
Create or replace view postgress
SQL
-1 vote120 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote137 views1 answer
Postgres in operator with comma separated values
SQL
0 vote90 views1 answer
Sqlalchemy filter relationship
SQL
0 vote193 views1 answer
How do you insert boolean to postgresql
SQL
0 vote126 views1 answer
Acutal month year
SQL