Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
from temp1 a,b.temp2
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.
You made a mistake and your query needs to be:
from temp1 a,
temp2 b /* not b.temp2 */