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,
from t_cust_subscription_summary a, t_lineitem b,
tr_cust_subscription_type c, t_pkg d
*** where a.reservation_no *= b.order_no
a.season = @season and a.type in (2,4,6,7)
b.primary_ind = 'Y' and b.perf_no = 0
and a.type = c.id
order by a.type