Outer Join 2 tables

[miro_kopecky]

Hello,
I have table_1 (PathMy, Word) and table_2 (PathMole, Word, WordCount, WordHex).
PathMy and PathMole have same values in rows, but Word are different.
I need Outer Join by PathMy, Word row from both tables but I cant figure out how to write this script.

If anyone could help me with this I would be very greatfull...
Thanks in advance.

[CarlosAMonroy]

Hi Miro,

Did you try 'Concatenate' or Join? That way you will have values from both tables. But you have to be aware of how each of those append data.

Hope that helps,
Carlos M

[miro_kopecky]

I didnt try that..but how do I write that script please?

[CarlosAMonroy]

Could be something like:

Table1:
Load
PathMy,
Word
From Table1;

Concatenate (Table1)

Table2:
Load
PathMole,
Word,
WordCount,
WordHex
From Table2;

That way you will have both values on 'Word' field. It all depends on the output you want to get.

Carlos M