Outer join

[jleberre]

Hello

I would like to merge 2 tables like this:

tab1: (A+B = Primary key)

A, B

1, a

1, b

2, c

3, c

-, d

- e

tab2: (A = Primary key)

A, C

1, xx

2, yy

3, zz

result -> tab3:

A, B, C

1, a, xx

1, b, xx

2, c, yy

3, c, zz

-, d, -

-, e, -

Can I use a outer join?

tab3:

load * resident tab1 outer join load * resident tab2

I'm not sure that "-,d" and "-,e" entries of tab1 will be present in tab3

thanks!

[micheledenardi · Accepted solution]

Of course, you can use Outer Join

[antoniotiman]

May be

tab2:
Join
LOAD * Inline [
A, C
1, xx
2, yy
3, zz];

[jleberre]

ok, thank you!