Multiple conditions on tMap

[FGuijarro]

Hi,

I am developing a process from 4 input tables (A, B, C, D).

-Relation between A and B is a1 (a1 is in table A and B)

-Relation between B and C is b1 (b1 is in table B and C)

-Relation between C and D is c1 (c1 is on table C and D)

Conditions are in columns on table B and D.

Output contains columns from A, B, C

How can I develope process the process with the tMap?

If I choose a main table (A), then B, C, D are lookup processes?

Which are the optionsfor this process?

Thank you for the help.

[XJ_1630]

for completeness

if you are joining datasets from the same DB:

do the joins in SQL and use the result as your input

[FGuijarro]

Thank you all, design is already done and working with "select as Best" from gjeremy1617088143