I would like to create a “Cluster Join” that joins multiple tables. However, I am having an issue creating a Left Outer Join between two of the tables.

I would like to return all of the rows in the “Host Data Source” even if no matching rows are in the “Target Data Source”. Because these tables have millions of rows, I want this join to be done on the Database not in hold files. I am using WF 5.3.

Any suggestions on how to get this to work?

This message has been edited. Last edited by: JChristy,

Hi Jen,

Has this issue regarding joins been resolved?

I ran a bit search on Focal Point and came across the idea that either MATCH or JOIN may be used, depending on your database.

Here are some suggested manuals regarding joins which may be of interest.

Hope it helps.

Cheers,

Kerry

My understanding is that cluster joins can only be inner joins. Can outer joins be used?