Query equivalent to a left single match join that only returns one record per key match.

Query equivalent to a left single match join that only returns one record per key match.

Query equivalent to a left single match join that only returns one record per key match. Resolution:
In a Left Single Match join, data will be kept (and columns added) only for rows that are available in the current data table. If additional rows exist in the new data, they will not be added to the current data table. If there are duplicates of the identifiers, only one value from the new data will be kept and added to the existing rows. You can achieve a left single match join using the following query, which uses an inner query to extract unique values from tableB, then applies a LEFT join on tableA and the new inner table.