Re: select data from two tables without join statement !!
> I need to join data from two tables but without using left join statement.
> Ex: select t1.*,t2.* from t1,t2 where t1.id=t2.id;
That is a join. A comma join.
> I don't want to use (LEFT JOIN), because I noticed that it takes longer time than using (WHERE) clause.
Don't know what you think you "noticed", but it's incorrect. There is no performance diff. Use a Left Join.
Subject
Written By
Posted
Re: select data from two tables without join statement !!
April 15, 2014 11:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.