1 Reply Latest reply on Mar 22, 2019 12:30 PM by 3894815

    Join Condition


      Select a.col1,b.col2

      from temp1 a,b.temp2

      where a.id=b.id

      and a.emp_no=b.emp_no;


      I have tried this kind of join format query.


      In 4th line , am getting error


      Can any one suggest, how to write 2 join condition in where clause. thanks.