I have two tables, one is a list of hospitals, and the other table is a main table which has entries, which are produced from a simple form. So user can enter details on form and they appear in table - main table.
What i need to do is generate a query which shows ALL hospitals from the hospital table, but then also shows any entries from main table, against any of those hospitals. There will only be one entry per hospital.
Can anyone help