select tb_sell_plan.tradecode,tb_sell_plan.fullname,tb_sell_plan.unit,tb_sell_plan.qty,tb_sell_plan.price,tb_sell_plan.tsum,tb_resell_detailed.qty,tb_resell_detailed.tsum form tb_sell_plan,tb_resell_detailed where tb_sell_plan.tradecode=tb_resell_detailed.tradecode
------解决方案--------------------
select tb_sell_plan.tradecode,tb_sell_plan.fullname,tb_sell_plan.unit,tb_sell_plan.qty,tb_sell_plan.price,tb_sell_plan.tsum,tb_resell_detailed.qty,tb_resell_detailed.tsum “form” tb_sell_plan,tb_resell_detailed where tb_sell_plan.tradecode=tb_resell_detailed.tradecode
------解决方案--------------------
------解决方案--------------------
- SQL code
select tb_sell_plan.tradecode,tb_sell_plan.fullname,tb_sell_plan.unit,tb_sell_plan.qty,tb_sell_plan.price,tb_sell_plan.tsum,tb_resell_detailed.qty,tb_resell_detailed.tsumFROM tb_sell_plan,tb_resell_detailed where tb_sell_plan.tradecode=tb_resell_detailed.tradecode