left join issue

Tue, 07 May 2013 16:19:22 GMT

hi all,

i have 3 tables and i want to left join but not getting desired results:

Table 1:

client value

a 10

b 5

c 6

table 2:

client category

a xxx

c aaa

table 3:

client category

b yyy

desired result:

client value category

a 10 xxx

b 5 yyy

c 6 aaa

when use left join, result is

client value category

a 10 xxx

b 5 -

c 6 aaa

left join statement used is below:

test:

load client,

value

from table 1

left join

load client, category from table 2

left join

load client, category from table 3

final:

noconcatenate load

client,

value,

category from resident test

drop table test

please advise how to get desired result from the 3 tables using left join or some other way

thanks in advance

Re: left join issue

Gysbert_Wassenaar — Tue, 07 May 2013 16:24:57 GMT

You need to concatenate table2 and table3 first and then right join it with table1.