Creating a query to show all records from one table plus those that are linked from another
Posted on 2016-10-19
I think my requirement should be quite simple, but just cannot seem to figure it out.
I have two related tables - Drivers and Journeys.
I am trying to construct a query that will list ALL drivers and then details of their future [date>=Date()] journeys if they have any.
Maybe like this....
John Smith - Journey1
John Smith - Journey2
Jim Black - Journey3
Fred White - Journey4
Fred White - Journey5
All my attempts so far will only list drivers if they have a journey.
Hope someone can give me a nudge in the right direction.