SQL Server

[Akshaya]

Hi,

Subject: "The table 'SW_PROVIDER_GRP' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause."



SELECT l.swLeadId, pr.swregion 'Rep Region' FROM person pr, PROVIDER_GRP h, LEAD l,
REGION g, SITE s
WHERE
h.swProviderGrpId = l.swSalesTeamId AND
h.swpersonid = pr.swpersonid AND
l.swSiteId = s.swSiteId AND
g.swRegionId = s.swRegionId AND
l.swstatus = 'Open'AND
g.swname = 'West'



I want to see all the leads irrespective of the swSalesTeamId, which is a column in the sw_lead Table (swSalesTeamId is a not null column and swLeadId is the Primary column). If I do an outer join "h.swProviderGrpId =* l.swSalesTeamId" I get a message

"The table 'SW_PROVIDER_GRP' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause."
And if I make the "h.swpersonid =* pr.swpersonid", It takes ages to run the query without returning any results.

Is there any work around or solution to my problem? I want to use an outer join with an = Join on the same table in the same query.

Thanks in advance

Regards,
Raghuveer
rvbandaru@yahoo.com



Raghuveer Bandaru
Software Engineer