How

[subbareddykm]

How to use multiple Left Joins.

For Exp:

I have 7 Tables

Table1:

Left Join

Table2:

>>>If I use

Left Join (Table2)

Table5:

Its showing error Table Not found(Table2)

If i use Left keep its working But its giving Sythatic keys.

CAn any one tell me how to solve this ?

[oknotsen]

You can only join with tables that you have already loaded.

So if you load table1 followed by table2, you can join table2 with table1 but you can not join table1 with table2.

[Anonymous]

Table1:

Left Join

Table2:

   >>>Rename table2 to table1

Left Join (Table1)

Table5:

Now it will not throw any error because earlier you were joinint to table2 which is already join to table1

[MarcoWedel]

Hi,

Table1:

Left Join

Table2:

only creates Table1, so there is no Table2 to join with in your subsequent load.

hope this helps

regards

Marco