高手们来看看哈,老是出现tb_sell_plan附近有语法错误 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.tsum
FROM
tb_sell_plan,tb_resell_detailed where tb_sell_plan.tradecode=tb_resell_detailed.tradecode