dw的in问题
fanbo 2007-11-05 11:57:56 在数据窗口对象的数据源里面
这个可以正常的建立数据源,retrieve()是正确的。
SELECT pub_shop.shopcd,
pur_purchasebilldetail.purchaseno,
pur_purchasebilldetail.purchaselno,
pur_purchasebilldetail.prodcd,
pur_purchasebilldetail.lotno,
pur_purchasebilldetail.purchaseqnty,
pur_purchasebilldetail.basicpurchaseqnty,
pur_purchasebilldetail.basicrealqnty,
pur_purchasebilldetail.unitcd,
pur_purchasebilldetail.basicunitcd,
pur_purchasebilldetail.purchaseprice,
pur_purchasebilldetail.tax,
pur_purchasebilldetail.totalmny
FROM pub_shop,
pur_purchasebilldetail
WHERE pur_purchasebilldetail.purchaseno in (select pur_purchasebill.purchaseno from pur_purchasebill where pur_purchasebill.updatetime > '2007-03-30')
可是设置了变量后,这个是错误的,为什么,又该怎么改?
SELECT pub_shop.shopcd,
pur_purchasebilldetail.purchaseno,
pur_purchasebilldetail.purchaselno,
pur_purchasebilldetail.prodcd,
pur_purchasebilldetail.lotno,
pur_purchasebilldetail.purchaseqnty,
pur_purchasebilldetail.basicpurchaseqnty,
pur_purchasebilldetail.basicrealqnty,
pur_purchasebilldetail.unitcd,
pur_purchasebilldetail.basicunitcd,
pur_purchasebilldetail.purchaseprice,
pur_purchasebilldetail.tax,
pur_purchasebilldetail.totalmny
FROM pub_shop,
pur_purchasebilldetail
WHERE pur_purchasebilldetail.purchaseno in (select pur_purchasebill.purchaseno from pur_purchasebill where pur_purchasebill.updatetime > :ad_lastdate)