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
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