Hello all,

I'm currently working with two tables and I need to use a full outer join to get data from both tables regardless of them matching or not.

The syntax i am using is:
join full_outer field1 in table1 to field1 in table 2

the above gives me an error...

I have read that the Match command can be used instead, i have tried it however i dont get the expected results...

can we do full outer join in wf?

Thanks
Cynthia

Cynthia

You can always use sql passthru as a fall back to do full outer as it is not directly supported in wf.

Match syntax would be

MATCH FILE table1
SUM/PRINT

BY field1 <-- names and format must match
RUN
FILE table2
SUM/PRINT

BY field1
AFTER MATCH HOLD OLD-OR-NEW
END

Post what you did on MATCH and we can tell you what's wrong

Regards

John

Hi John,

Thanks for the tip!
I finally got my tables to work using a join and playing with the dates. I added one to last year's data so that last year's and this year's data would line up.

Thanks
Cynthia