select org_code,
material_managed,
plant_code,
company_code,
cost_estimate_num,
currency_key,
local_currency_amt,
signed_local_amt,
base_uom,
quantity,
stock_quantity,
posting_date,
entry_date,
year_and_day,
year_and_week,
year_and_month,
year_and_quarter,
year_number,
month_of_year,
week_of_year,
day_of_year,
day_of_week,
document_date,
shelf_life_date,
production_date,
material_document_code,
material_document_year,
material_doc_item,
line_guid,
material_num,
debit_credit_indicator,
delivery_costs,
alt_control_amt,
entry_quantity,
quantity_val,
receiving_material,
receiving_plant,
company_name,
storage_location,
Library_age,
material_id
from dwd_Hon_Inventory
SELECT a.id,
a.org_code,
a.cost_estimate_number,
a.fiscal_year,
posting_period,
sub_period,
currency_type,
a.price_unit,
a.price_control,
standard_price,
period_unit_price,
currency_code,
a.created_time,
a.created_by,
a.updated_time,
a.updated_by,
a.is_delete,
a.create_time,
a.update_time,
b.id,
b.org_code,
costing_number,
costing_type,
b.valuation_area,
valuation_type,
special_stock_indicator,
sales_document,
sales_document_item,
wbs_element,
b.material_number,
b.created_time,
b.created_by,
b.updated_time,
b.updated_by,
b.is_delete,
b.create_time,
b.update_time,
c.id,
c.org_code,
material_id,
c.material_number,
c.valuation_area,
c.price_control,
c.price_unit,
valuation_class,
previous_price_control,
previous_price_unit,
previous_valuation_class,
prior_year_price_control,
prior_year_price_unit,
prior_year_valuation_class,
c.fiscal_year,
current_period,
maintain_status,
product_cost_number,
c.cost_estimate_number,
quantity_based_costing,
material_origin,
c.created_time,
c.created_by,
c.updated_time,
c.updated_by,
c.is_delete,
c.create_time,
c.update_time,
field3,
field4,
field5,
sap_time
FROM
ods_hon_material_period_summary_record a
LEFT JOIN ods_hon_material_header_document b
ON a.cost_estimate_number = b.costing_number
LEFT JOIN ods_hon_material_valuation c
ON b.valuation_area = c.valuation_area
AND b.material_number = c.material_number我想将这两张表链接起来我的关联条件是什么,并且如何不会数据扩散
作者长时间未进行写作，感到迷茫且不知所措。面对诸多问题与困惑却难以诉诸文字，仅能通过撰写文章来寻求内心的平静。
扫一扫
3185
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
