Hi,

When I run the following sql statement, I got error message:

Cannot specify outer join operators in a query containing joined tables.
View or function 'v_Address' contains outer join operators.

SELECT Name_a.FullName,
v_Address.Line1,
v_Address.CityName ,
v_Address.ProvinceName,
Phone.PhoneNumber,

FROM PolicyItem
JOIN Client C
ON ( PolicyItem.ClientId = C.ClientID )
JOIN v_Address
ON ( PolicyItem.AddressId = v_Address.AddressId )
JOIN v_NameProper Name_a
ON ( C.ClientNameId = Name_a.NameId )
LEFT OUTER JOIN  Phone
ON ( Name_a.NameId = Phone.NameId )
WHERE ( PolicyItem.PolicyItemId = @PolicyItemId )

v_Address does contain outer join. Anybody know why and how to change the
sql to make it work?

Your help will be very much appreciated.

Joan

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
Convert *= / =* to outer joins (ANSI compliant)
SQL Include Empty Months
create a sp from query output