topic Re: Two tables into 1 field (which is in a different table)? in App Development

Two tables into 1 field (which is in a different table)?

Thu, 02 Jun 2016 13:01:07 GMT

Hello!

Can someone help me figuring our the following? I'm trying to combine 3 tables into one:

Table 1 [forms] Contains:

- LeadId

- ContactId

Table 2 [contacts] Contains:

- ContactId

- Name

Table 3 [leads] Contains:

- LeadId

- Name

I want the field 'Name' of table 2 and table 3 to be put into table 1 based on the lead/ContactId where ContactId is more important then LeadId (so if both LeadId and ContactId contain data, the name of the table Contact is taken). So what I finally want:

Table [forms]

- LeadId

- ContactId

- Name

I have tried to achieve this with left join but this only joins one of the 2 into the field Name, if I rename one of the two to Name1 both are displayed.

Thanks in advance

Re: Two tables into 1 field (which is in a different table)?

sunny_talwar — Thu, 02 Jun 2016 14:04:32 GMT

What if you do simple joins instead of left join?

Table1:

LOAD LeadId,

ContactId

FROM ...;

Join (Table1)

LOAD ContactId,

Name

FROM ....;

Join (Table1)

LOAD LeadId,

Name

FROM ....;

Re: Two tables into 1 field (which is in a different table)?

Thu, 02 Jun 2016 14:08:23 GMT

I also tried a simple join, still the same result. Only 1 of the 2 tables is joined into table 1 (the one which is on top).