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:
FROM Sheet1_ FULL OUTER JOIN Sheet2_
WHERE Sheet1_.Foundary# = Sheet2_.Product#
To make it clear...
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.