I have a number of tables, whereby I want to join the tables to a parent table. My problem is that I wish to show every row of the table, but only show these rows once. This is hard to explain in text, so I have provided a example table below, which is the
output I expect from the sql below. The #SI is the parent table.
(Note that I have only created the example with 4 tables. The actual number of tables will be more that this).