haifeng585 2006-5-15 12:36
SQL查询错误，请您帮忙提个意见（在线）！
我调用的这个查询语句sql="select product.name,product.stocks,product.id,purseTable.id,purseTable.pId,purseTable.purseCount,purseTable.price,purseTable.getProductionName,purseTable.checkName,purseTable.purseDate from purseTable,product order by purseTable.id desc "提示“参数不足，期待是1.请问怎么回事？
huaerfeifei 2006-5-15 12:38
product与pursetable的关联
wusong147 2006-5-15 12:38
一般来说，总要 where product.fieldXX = pursetable.fieldXXX 吧，要不，二表怎么联系。
wudalang 2006-5-15 12:39
purseTable.getProductionName有问题吗？还有是不是需要在两个字段后面加上“AS XX”用以区分呢？