-- century_emember.sp_SelectDetailOrder (PROCEDURE)
begin
	SELECT 	DSO_ID, DSO_OrderNo, DSO_Procod, ifnull(DSO_Qty, 0) as DSO_Qty, DSO_SalePrice, 
		ifnull(DSO_NettPrice, 0) as DSO_NettPrice,
		ifnull((DSO_SalePrice * DSO_Qty),0) as Subtotal, 
		p.Pro_Code, Pro_Name, Pro_Image,
		ifnull('0', '0') as Pro_Weight
	from century_emember.TD_SalesOrder d 
	left join Master_centuryApp.MH_Product p on d.DSO_Procod = p.Pro_Code
	LEFT JOIN Master_centuryApp.MD_Product pd ON p.Pro_Code = pd.Pro_Code
	where DSO_OrderNo = id
	GROUP BY DSO_Procod;
end