I have 2 tables: table A contains groups and table b contains items. 1 record in table A can link to many in table B, but also 2 records in table a could link to the same record in table B.
I want to score the records in each of the two tables, in order to understand and prioritise which unique combination has the highest score. So, I need a third table which is automatically generated and where each row is a distinct combination of a single record from table A and a single record from table B, where they are linked according to the above.
In SQL this would be ‘full outer join’ of these 2 tables.
Is this possible?