I have one confusion. I have been told that if I am joining the two tables using the left outer join then I cannot use columns from the right side table in where condition, otherwise it will act as a inner join.
e.g. select tr.* from trans tr LEFT OUTER JOIN detail d on tr.hprop = d.hprop where tr.hmy between 1 and 100 and d.hprop = 2 ....(will this act as inner join as I have mentioned d.hprop =2 in where condition?)
Is it correct? anf if yes then how?
View Complete Post