How to join data

[Sra1bandi]

Hi team 

i have 2 tables

Table 1:-

Code     Id

1             11AC

2             BR25

3              A810

Table2:-

Key            Id             Username

1               11AC          Raju

1               11AC         Vamsi

1               11AC           sai

I need to show the table like below

Required Output Table:-

Key     Id               Username

1               11AC          Raju

1               11AC         Vamsi

1               11AC           sai      

2             BR25             -

3              A810             -

When i am trying to do  left join i am getting result like all user names are assigning for each id but i need to show usernames only for ID= 11AC three usernames.

Regards,

Sravan.

[Marijn]

Hi Sravan,

I'm not sure what you need exactly, but from the example this should do the trick.

main_table:
load *
resident table2;

outer join (main_table)
load
   Code as Key,
   Id
resident table1;

drop tables table2,table1;