troubleshooting Question

Outer join operators cannot be specified in a query containing joined tables.

Avatar of Richard Comito
Richard ComitoFlag for United States of America asked on
Microsoft SQL Server 2005SQL
3 Comments2 Solutions2929 ViewsLast Modified:
I am changing some code to add in inner and outer joins.  But I am getting the following error on some of the code and I know what is causing it but not sure how I go about fixing it.

The error that I am getting is:
Outer join operators cannot be specified in a query containing joined tables.

And what is causing it is a join in the where clause that as this for the join  *=.  Here is the example of the code that I am trying to change.  I put *** by the line that I am trying to move up to the FROM so that I can add the join.

select distinct a.customer_no, a.reservation_no, a.type,
 c.[description] as new_sub_type,
 b.pkg_no
from t_cust_subscription_summary a, t_lineitem b,
tr_cust_subscription_type c, t_pkg d
*** where a.reservation_no *= b.order_no
and
a.season = @season and a.type in (2,4,6,7)
and
b.primary_ind = 'Y' and b.perf_no = 0
and a.type = c.id
order by a.type

Thanks
ASKER CERTIFIED SOLUTION
Answer_Me

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros