1 Reply Latest reply on Feb 5, 2015 4:26 PM by Patrick A Van Der Hyde

    Table connected to several other tables

    roy.kemble

      Hi

       

      I have 2 tables in an SQL database that are all linked together using keys, the problem I have is that each table has a link to a separate table containing personnel records.

       

      2015-01-14 16_01_12-Tableau - Book4.gif

      I have tried linking the personnel table to the relevant keys in the 2 other tables, but this only imports personnel records where there are related records in both the other tables.

       

      This is not always the case as there are often records in one of the other 2 tables without matching records in the other.

       

      Any help greatly appreciated