Hope someone can help with this. Its something I understand why doesn’t work as currently is, but wondering if there is a way to return the results I would like.
Its a fairly simple table structure, with a main table ‘lodges’, and a linked table ‘updates’. So any lodge can have multiple updates.
So I can have a simple query:
SELECT DISTINCT lodges.LodgeID, Lodge FROM lodges
Which will list all the lodges.
Or I can use an INNER JOIN to return lodges where there is a matching record in the linked table:
SELECT DISTINCT lodges.LodgeID, Lodge, update_date INNER JOIN lodge_updates ON lodges.LodgeID = lodge_updates.LodgeID
But that will filter the list of lodges to only show lodges that have a record in the update table.
Is it possible to join the tables, but still list all lodges whether they have a record in the update table or not?
The idea is to show a list of all lodges, with an indication of whether or not they have any updates.
Hope that makes sense.
Thank you.