Can you inner join multiple tables

But how to include these in the result too? It takes the first table customer and joins all its rows 4 of them to the next table city. The result of this is 4 rows because the customer could belong to only 1 city. Then we join these 4 rows to the next table country , and again we have 4 rows because the city could belong to only 1 country.

The query is written in such manner it returns 4 rows would be the answer to the following: Return names of all customers as well as cities and countries they are located in.

Return even customers without related cities and countries. For such pairs return all customers. Return even pairs not having a single customer. HallPref1, r. HallPref2, r. Halls AS h ON r. Improve this question. Neuron 4, 4 4 gold badges 24 24 silver badges 47 47 bronze badges. Bob Sanders Bob Sanders 4, 4 4 gold badges 16 16 silver badges 11 11 bronze badges. Add a comment. Active Oldest Votes. StudentID , s. FName , s. LName , s. Gender , s. BirthDate , s.

Email , r. HallPref1 , h1. HallPref2 , h2. HallPref3 , h3. Halls AS h1 ON r. Halls AS h2 ON r. Halls AS h3 ON r. Improve this answer. Taryn Taryn k 54 54 gold badges silver badges bronze badges. This works with just one preference, but how would I want to edit this to make it work with 3 preferences?

BobSanders just updated my answer, then if you don't want the HallPref number just drop those columns — Taryn. YasirA 9, 2 2 gold badges 36 36 silver badges 60 60 bronze badges. OrderID, Customers. CustomerName, Shippers. ShipperID ;. Exercise: Choose the correct JOIN clause to select all records from the two tables where there is a match in both tables.

Report Error. Your message has been sent to W3Schools.