Help with SQL query
Not sure if this is possible, as it involves finding results where no records have been added.
Basically I have two related tables - lodges, and lodge_rates.
And would like to return a list of all lodges where no rates have been added yet.
SELECT * FROM lodges
INNER JOIN lodge_rates ON lodge_rates.LodgeID = lodges.LodgeID
Returns a list of lodges that have had their rates added, is there a query that would return lodges which have not had rates added?