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 vote139 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
36 votes255 views6 answers
Change column data type sql
SQL
2 votes171 views1 answer
Oracle log files
SQL
0 vote92 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote145 views1 answer
Php get closest location by latitude longitude
SQL
0 vote136 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote139 views1 answer
Postgres meta command to show all rows in table
SQL
5 votes148 views3 answers
Sql server utc to local
SQL
6 votes148 views3 answers
Sql select last id
SQL
1 vote157 views1 answer
Postgresql datetrunc too slow
SQL