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 vote337 views4 answers
Restart mysql server ubuntu
SQL
11 votes362 views2 answers
How to import mysql database command line
SQL
33 votes339 views6 answers
Change column name in mysql
SQL
0 vote325 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
2 votes334 views3 answers
How to get second highest salary in each department in sql
SQL
15 votes353 views3 answers
Postgresql change column type
SQL
19 votes325 views2 answers
Mysql add column after another
SQL
0 vote325 views1 answer
Oracle procedure teamplate
SQL
0 vote343 views1 answer
Sql put two columns into one
SQL
4 votes328 views1 answer
Create db table
SQL