LEFT SINGLE MATCH in SQL
I need to modify SQL query in the information designer by implementing what one can find when joining columns from
a table based on a matching column - LEFT SINGLE MATCH, within Spotifre.
Left single match
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.
If anyone can assist in defining such an SQL query, I would really appreciate that.