In Excel Power Query I am trying to match two tables where one column should match (i.e. GUID), but the other shouldn't (i.e. Value) so that I end up with only the different values from the join/merge.
So the equivalent in SQL would be this:
Is this possible at all or will I need to use some kind of INDEX MATCH or VBA code to achieve this?![]()
SELECT A.* FROM dbo.A INNER JOIN dbo.B ON A.B_GUID = B.GUID WHERE A.Value <> B.Value
Attached you will find an example file with the result (green header) that I expect.
Bookmarks