How to join 3 and more tables in SQL?

by

Assuming that you have table 1, table 2 and table 3. Let´s create a simple example.

table 1: employees: id, department_id, first_name, last_name, salary…

table 2: departments: id, location_id, department_name…

table 3: locations: id, city…

department_id and location_id are foreign keys. Employees have a department_id and Departments have a location_id. You need this foreign keys in order to JOIN different tables.

Then you can use this query to join the tables:

SELECT first_name, salary, department_name, city
FROM departments JOIN employees USING (department_id)
JOIN locations USING (location_id)
GROUP BY first_name, salary, department_name, city;

If you want to learn more about different kind of joins I found a good explanation here.

Hope it helps!

More Related Contents:

  1. How to use GROUP BY to concatenate strings in SQL Server?
  2. SQL, Auxiliary table of numbers
  3. ListAGG in SQLSERVER
  4. Equivalent of LIMIT and OFFSET for SQL Server?
  5. DateTime2 vs DateTime in SQL Server
  6. SET versus SELECT when assigning variables?
  7. Is it possible to for SQL Output clause to return a column not being inserted?
  8. Generate Dates between date ranges
  9. How to print VARCHAR(MAX) using Print Statement?
  10. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  11. Query error with ambiguous column name in SQL
  12. Why (and how) to split column using master..spt_values?
  13. How would you implement sequences in Microsoft SQL Server?
  14. What does =* mean?
  15. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  16. SSIS Package not wanting to fetch metadata of temporary table
  17. SQL Select Upcoming Birthdays
  18. How to store historical records in a history table in SQL Server
  19. SQL GROUP BY CASE statement with aggregate function
  20. How can I include null values in a MIN or MAX?
  21. Favourite performance tuning tricks [closed]
  22. Query a database based on result of query from another database
  23. How to delete the top 1000 rows from a table using Sql Server 2008?
  24. CHECK CONSTRAINT on multiple columns
  25. INSERT VALUES WHERE NOT EXISTS
  26. Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
  27. SQL count consecutive days
  28. Inner Joining three tables
  29. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]
  30. Executing SQL query on multiple databases

Leave a Comment