Select b.*,a.PNAME,a.CARDNO,b.DFEE/b.DNUM as price
From drugsale b,daily a
Where a.SHEETNO=:sheetno
and a.SHEETNO=b.SHEETNO特别是'/'和'a.SHEETNO=:sheetno',我看不懂,各位看看?
From drugsale b,daily a
Where a.SHEETNO=:sheetno
and a.SHEETNO=b.SHEETNO特别是'/'和'a.SHEETNO=:sheetno',我看不懂,各位看看?
=:sheetno说明sheetno是一个参数,执行前要赋值
adoquery.peramenters[0].value:='123';