Trouble joining tables - tables share the same fields

[darren_dixon]

Hi,

Please, please help! I am having trouble linking 3 tables together. I keep getting syn tables as all three tables share the same fields.

The tables should link like this:

Applications:          Link:                    Applicants:

ApplicationID         ApplicationID

                            ApplicantID             Applicants

All 3 tables include the following fields:

• "Int_ID"
• "DB_Action"
• "Session_Token"
• "Audit_Date"

Applications:

Load

ApplicationID,

InputDate,

Username,

Password;

SQL Select *

From Audit.dbo."tbl_Applications";

Link:

Load

ApplicationID,

ApplicantID;

SQL Select *

From Audit.dbo."tbl_Applications";

[Applicants]:

Load

ApplicantID,

First_Name,

Last_Name,

DoB;

SQL Select *

From Audit.dbo."tbl_Applications";

[#2]

Hey,

Qlikview automatically creates links between tables with the same fields. If you don't want this to happen you have to change the name of the fields. You can do this either manualy or use the Qualify function.

Hope this helps.

Gr.

Frank