Hello !
I try to joint table A to table B:
The data in the A field(Fa) should be equal to the data in one of two fields (F1, F2) in B.
I have been trying to built a theta-joint and to write the right expression in Joint Editor :
- (Fa=F1) OR (Fa=F2)
- Fa between F1 AND F2
It didn't succeed, always getting a SQL Error while Reporting ....
Any help is warmly welcome !
Benouche
I try to joint table A to table B:
The data in the A field(Fa) should be equal to the data in one of two fields (F1, F2) in B.
I have been trying to built a theta-joint and to write the right expression in Joint Editor :
- (Fa=F1) OR (Fa=F2)
- Fa between F1 AND F2
It didn't succeed, always getting a SQL Error while Reporting ....
Any help is warmly welcome !
Benouche