I set ANSI92 to "yes" in order to set inner join between the table A and table B.But users didnot accept ANSI 92 standard.
I have 2 questions
1)My problem is how we can set Inner join between the tables with out specifying ANSI92 "Yes"
2)I need to do join order move from "where" clause to "from" clause for increase the performance.How can i proceed this
with out specifying the ANSI92 Yes
Suggestions greatly appreciated.