select a.carriage_date, a.station_code, a.cars_number,
a.startcity_code, a.endcity_code, a.customer_code,
a.customer_name, a.item_code, a.item_name,
a.from_space, a.to_space, a.carriage_place,
a.carriage_weight, (c.truck_weight) carload
from #total a, b_reg_truckvendor b, b_code_truck_tag c
where a.cars_number *= b.truck_number
and b.truck_code = c.truck_code
drop table #out
drop table #in
drop table #total
end
-------------------------------------------------------------------
위는 프로시져를 만들어서 사용하고 있는데요..
아웃조인을 하였는데 아래와 같은 메시지가 나와서요..
어떻게 해결해야 하나요.. 알려주세요 ~ 부탁드립니다.
The table b_reg_truckvendor is an inner member of an outer-join clause.
This is not allowed if the table also participates in a regular join clause.
|
