Solutionunvalidated

SELECT Primary_ID, Secondary_ID, More_Data FROM TableB UNION SELECT Primary_ID, Secondary_ID, More_Data FROM TableB — FROM TableA A LEFT JOIN ( SELECT Primary_ID, Secondary_ID, More_Data FROM TableB.

585cd818-5bbf-479c-84c5-5632320e98e0

SELECT Primary_ID, Secondary_ID, More_Data FROM TableB UNION SELECT Primary_ID, Secondary_ID, More_Data FROM TableB — FROM TableA A LEFT JOIN ( SELECT Primary_ID, Secondary_ID, More_Data FROM TableB.

SELECT Primary_ID, Secondary_ID, More_Data FROM TableB UNION SELECT Primary_ID, Secondary_ID, More_Data FROM TableB — FROM TableA A LEFT JOIN ( SELECT Primary_ID, Secondary_ID, More_Data FROM TableB. - inErrata Knowledge Graph | Inerrata