I am trying to create a report that gives me the result of 2 tables.
The two tables look like this:
Trips DailySummary Vehicles
Vehicle_ID Vehicle_name Vehicle_Id
Date Date Vehicle_name
Now, I need to join the Trips table to the DailySummary table. Then I need to check for only the records that belong to the DailySummary table, but do not exist in the Trips table.
Any idea on how to do this?