Dear Friends,
I am having two tables TB_PERSON_P and TB_PERSON_R
both having a common column R_ID
now we can write two query:
select R_ID from TB_PERSON_P P,TB_PERSON_R R where P.R_ID=R.R_ID
and
Select R_ID from TB_PERSON_P P join TB_PERSON_R on P.R_ID=R.R_ID
which would be faster among these two statement?
Thanks!!