View previous topic :: View next topic
|
Author |
Message |
Ambili S
Active User
Joined: 06 Sep 2007 Posts: 112 Location: India
|
|
|
|
Hi
Below is the query :
Select C1,C2 from T1,T2 where T1.C1 = T2.C1
and C3 < ( Select NEW_COL from T3 where T1.C1 = T3.C1)
and C9 >= ( Select NEW_COL from T3 where T1.C1 = T3.C1)
and C11 > ( Select NEW_COL from T3 where T1.C1 = T3.C1) ;
Here when the above query runs , Select for T3 executes thrice.
Is there any way to tune this as the same column value is being checkd against three colums. |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Try
Code: |
Select C1,C2 from T1,T2,T3
where T1.C1 = T2.C1
and T1.C1 = T3.C1
and C3 < T3.NEW_COL
and C9 >= T3.NEW_COL
and C11 > T3.NEW_COL ;
|
|
|
Back to top |
|
|
Ambili S
Active User
Joined: 06 Sep 2007 Posts: 112 Location: India
|
|
|
|
Ashimer ,
This would give results from T3 table also. I do not want the data from T3. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Ambili S wrote: |
Ashimer ,
This would give results from T3 table also. I do not want the data from T3. |
god on a crutch.
Select t1.C1
,t1.C2 |
|
Back to top |
|
|
|