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 |
|
Ajitdsin
Starting Member
1 Post |
 Posted - 2005-05-30 : 07:13:22
|
| I have a query which is joined to other table asTable A as a left outer join (table b as b inner Join table c as c) on b.column_Nane = c.column_Name) on b.Column Name = a.column_nameNow i have 2 views View X and View YI want to left outer join the coumn of Table A with the column of views X and View Y in my query i mention a.cloumn_Name *= x.column_Nameand a.column_name *= y.column_NameIt throws erros mentioning, "Joint tables cannot be specified in a query containing outer join operators.What i want is all the records of table a be selected by doing an outer join query with both these views.Can ne 1 help me in this. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-05-31 : 01:35:23
|
| You cannot use both the old style (*=) join syntax and the new style (inner join) in the same statement.Give up the old style. It's inherently flawed.See BOL for details on how to specify an OUTER JOIN using the new syntax.HTH=================================================================The surest way to corrupt a youth is to instruct him to hold in higher esteem those who think alike than those who think differently. -Friedrich Nietzsche, philosopher (1844-1900) |
 |
|
|
|
|
|
Joins Help