I need to join 2 tables in Crystal reports XI, and need to apply a condition "or". by default it is giving "and" condition. in the Show SQL query there is no option for editing the sql query which was there in CR8.5 so can any body helps me how to change that condition.

Select t1.empid,t2.empid, t1.empName,t2.empName from emp t1, address t2 where t1.empid=t2.empid or t1.empName=t2.empName