Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Another Full Open Join Question

I am using Crystal11 to obtain a Full Outer Join on two excel tables from different files

The tables' contents are different with only a part # similar.

Here is my Add Command:

SELECT Sheet1_.Foundary#,Sheet2_.Product#

FROM Sheet1_ FULL OUTER JOIN Sheet2_

WHERE Sheet1_.Foundary# = Sheet2_.Product#

To make it clear...

In file/sheet:

Combined/Sheet1 I am trying to find all occurences of the same item in WhereIsIt/Sheet2 where Foundary# = Product#

My code gets the error:

Syntax error in date in query expression 'Sheet1_.Foundary#'.

I am running out of patience with myself.

Thanks for your suggestions.

JohnW

Not what you were looking for? View more on this topic or Ask a question