34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT c.*
FROM [TB_CWB] c
left join MS_GENERAL g
on g.[KEY_VALUE]=c.PRICE_CUR
where g.[KEY_TYPE]='CURRENCY'
SELECT c.*
FROM [TB_CWB] c
left join MS_GENERAL g
on g.[KEY_VALUE]=c.PRICE_CUR
where g.[KEY_TYPE]='CURRENCY'
SELECT c.*
FROM [TB_CWB] c
left join MS_GENERAL g
on g.[KEY_VALUE]=c.PRICE_CUR and g.[KEY_TYPE]='CURRENCY'
SELECT c.* FROM [TB_CWB] c left join MS_GENERAL g on g.[KEY_VALUE]=c.PRICE_CUR and g.[KEY_TYPE]='CURRENCY'
--where 改为 and ,如下:
SELECT c.*
FROM [TB_CWB] c
left join MS_GENERAL g
on g.[KEY_VALUE]=c.PRICE_CUR
and g.[KEY_TYPE]='CURRENCY'