Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-01-18 : 01:38:33
|
| Dear All,is there anyway to replace right outer join? coz,i'm trying to create an index on indexed view. i'm getting error, that too because of outer join. how can i replace this?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-01-18 : 02:04:54
|
Post your query here.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-18 : 04:15:08
|
| You can ,with a bit of rewriting , do it normally with a LEFT join. But it sounds like this could cause similar problems.Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-18 : 23:32:41
|
| the query is like thisselect * FROM dbo.Table19 i LEFT OUTER JOIN dbo.Table11 t ON i.COLUMN16 = t.COLUMN1 LEFT OUTER JOIN dbo.Table13 c ON i.COLUMN17 = c.COLUMN1 LEFT OUTER JOIN dbo.TABLE20 iu ON i.COLUMN1 = iu.COLUMN1 LEFT OUTER JOIN dbo.view2 u ON iu.COLUMN4 = u.Uom_Id LEFT OUTER JOIN dbo.Table25 mm ON i.Column1=mm.Column1 LEFT OUTER JOIN dbo.Table23 mod ON i.Column1=mod.Column1 LEFT OUTER JOIN dbo.Table117 ig ON i.Column20=ig.Column1 LEFT OUTER JOIN dbo.table22 pd on i.column1=pd.column1 WHERE i.Column16 <> '11'VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-18 : 23:40:25
|
| i've just replaced the left outer join with left join. and same number of rows displayed.is there any difference between left outer join and left join?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-19 : 03:53:11
|
| Nope. they are the same. by the way what is your requirement here? Can you please explain. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-01-19 : 03:56:02
|
| actually i'm trying to create one view with schema binding option. but asthat is having another view as well as outer join, i was unable to create an indexed view. i can create the view as table dynamically. but what about outer join? that's why i'm asking the question. and one more post is there from me it is also relevent to this.i need support in this regard Mr. VisakhVinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-19 : 04:08:02
|
| So basically you are trying to replace view with table. Thats perfectly fine and you can use outer joins in same way as you do with the view. Didnt understand difficulty in that Vinod? |
|
|
|
|
|
|
|
|
replacing right outer join