I’m looking at 3 tables here with:
1 called Users
containing a UserID
.
UserID
is linked by a foreign key to UserID
in a table called Orders
.
Within Orders
there’s a PassengerID
linked by a foreign key to a table called Passengers
.
Is there anyway I can link these tables to identify the UserID
it’s associated OrderID
and that OrderIDs associated passengerID
.
JOIN
two tables?