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 votes281 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote279 views1 answer
Codeigniter dbforge add index
SQL
0 vote274 views1 answer
Postgres truncate with cascade
SQL
0 vote274 views1 answer
Update set with inner join oracle
SQL
0 vote295 views1 answer
Oracle query archive mode
SQL
1 vote307 views2 answers
Snowflake alter column data type
SQL
11 votes292 views1 answer
Mysql order by two columns priority
SQL
0 vote278 views2 answers
Return the number of records in a single table mysql
SQL
8 votes276 views1 answer
Oracle add month
SQL
0 vote284 views1 answer
Create relationship with betwen two tables in postgersql
SQL