Can we apply OR join between two tables.

 

I added two tables to the database expert. And in the links section I applied joins.

 

Lets say TabA, TabB.

 

There are two joins

1)  TabA.Col1 = TabB.Col1

2)  TabA.Col2 = TabB.Col2

 

I did these joins. But by default I think it applies "and" condition between these joins. But I want to apply "OR" join.

 

But couldn't find any option. How can we do this?

 

Thanks in advance.

 

Regards

 

Gowtham.