Good day to all I was wondering if it is possible to show all data in a datagridview that doesn't match from 2 tables?
Like Inner Join if you have at least 1 match data from the other table it will display it. What i want is to display
those data that doesn't have a match from the other table.
Here's my code:
Dim cmd As OleDbCommand = New OleDbCommand("SELECT Data1.ID, Data1.DateFile as [Date File] , Data1.Plate as [Plate #], Data1.Driver as Driver, Data1.EmpID as EmpID, Data1.OdometerBefore As [Odometer Before], Data1.OdometerAfter As [Odometer After], Data1.Gas as Gas, Data1.CostofGas as [Cost of Gas] FROM Data1 Inner Join Data4 on Data1.Plate=Data4.Plate", con)