select decode(产品编码FLAG,'0',field1,'1',field2,'2',field3,'3',field4) as 产品编码,decode(MEI.借贷,KMK.借贷,金额,-1*金额) AS 进货价格
from T_NGLKMEISD As MEI,T_NALKAMOKM As KMK
where MEI.CDE = inputCDE(输入的编码)这2章表通过什么字段关联?
from T_NGLKMEISD As MEI,T_NALKAMOKM As KMK
where MEI.CDE = inputCDE(输入的编码)这2章表通过什么字段关联?
使用DECODE函数可以避免重复扫描相同记录或重复连接相同的表. 同意
from T_NGLKMEISD As MEI,T_NALKAMOKM As KMK
where MEI.CDE = inputCDE(输入的编码)这段代码我敲在PL/SQL Developer中会报错的。
SQL command not properly ended