• Correction to the required solution:

    Using the sample tables provided in original post, the solution is to get only up to 4 addresses, even if each ROWID has more.

    Also, the result will be 5 columns thus:

    ROWID, Address1, Address2, Address3, Address4

    Each address will be a concatenated address (Address1 + Address2 + Address3 + ADdress4 + Postcode)

    Still stumped on how to achieve this, so any help is appreciated.

    Cheers, Danster