I have three tables.  One has.

TableA
month
customer
data

TableB
month
customer
data

I want to join Table A with Table B, but the customer fields in Table A and B don't match, So I need a junction table

TableC
Customer_from_Table_A
Customer_from_Table_B

In SQL I would just write
select *
from table A
left join tableC on TableA.customer = TableC.Customer_from_Table_A
left jion tableB on TableA.month = TableB.month and TableC.Customer_from_Table_B = TableB.customer

But I have to use the links thing instead.  When I do the arrows etc, I get the error:
Database connection error: If tables are already linked then join  type can not change.

I suspect, it's because Crystal is trying to join Table B to Table A before first joinging TableC to Table A when building the query.  How would I fix this?

Oh, yes.  Crystal reports XI



Edited by martingaleh - 19 Mar 2012 at 12:58pm