Hi,
I have a business rule to implement which involves two tables (call them T1 and T2). I want to check some values for records which are related on two columns in the tables (Call them col1 and col2). So in SQL my rule is:
Select
T1.col1,T1.col2,T2.col1,T2.col2
from T1
inner join T2 on T1.col1 = T2.col1 and T1.col2 = T2.col2
where t1.col3 = t2.col3
The problem is I can only configure a single column join in the join condition. If I specify a new row i the join condition it treats this as a new instance of the table and if I specify the additional join in the where clause, the passing rows works correctly but the failing rows is wrong.
???
Thanks,
Dan