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

    Join Condition

    3894815

      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.