高手们来看看哈,老是出现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
[解决办法]
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