Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Of course, you can use Outer Join
Of course, you can use Outer Join
May be
tab2:
Join
LOAD * Inline [
A, C
1, xx
2, yy
3, zz];
ok, thank you!