Skip to Content
0
Former Member
Sep 14, 2011 at 03:17 AM

ANSI92

17 Views

Hi

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.

Thanks..