日期:2014-05-20  浏览次数:20954 次

高手们来看看哈,老是出现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.tsum “form”……

------解决方案--------------------
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