以下的语名想只有 a.MC = '1'的数据取出 我写在后面后,发现a.MC 不为1的也取出了。请问怎么写
SELECT a.BH as bh, a.MC as mc, a.BHCW as bhcw,,b.mc as FLFPMZ,c.mc,d.mc as FLFPZY FROM YP a
left outer join cw b on a.bhcw = b.bh
left outer join FLFP c on a.flfpmz = c.bh and a.lb='门诊'
left outer join FLFP D on a.flfpzy = d.bh and d.lb='住院'
ORDER BY a.lb,a.BH
SELECT a.BH as bh, a.MC as mc, a.BHCW as bhcw,,b.mc as FLFPMZ,c.mc,d.mc as FLFPZY FROM YP a
left outer join cw b on a.bhcw = b.bh
left outer join FLFP c on a.flfpmz = c.bh and a.lb='门诊'
left outer join FLFP D on a.flfpzy = d.bh and d.lb='住院'
ORDER BY a.lb,a.BH
解决方案 »
- 求助 静态函数 引用非静态函数的问题 大家都来讨论下
- 拆分窗口通信问题?
- 摄像头抓下的彩图 转存 8位灰度图问题
- 请问 msn 聊天的窗口 是否是非模态的对话框,我用wtl做了开发了一个程序,弹出一个非模态对话框后 用alt+tab 无法看到这个对话框
- 最近急着要用COM做程序,大家给推荐几本快速入门的COM的书,最好有电子版的!
- FTP大放送,还有分拿!!!!!!!!!!!!!
- 关于Microsoft Date and Time Picker的使用问题!!!
- “梦的河流”在吗?
- 谁有《ATL开发指南》第二版的附书源码?
- VS2008的资源文件控件ID可以用中文吗?如果还是不可以,就暂先不转了。
- 谁知道 LZSS 算法
- 问个问题,类型转换
left outer join cw b on a.bhcw = b.bh
left outer join FLFP c on a.flfpmz = c.bh and a.lb='门诊'
left outer join FLFP D on a.flfpzy = d.bh and d.lb='住院'
join YP on a.mc = '1' //原来的语句中没有看到a.MC为'1'的条件
ORDER BY a.lb,a.BH
D.mc AS FLFPZY
FROM YP a LEFT OUTER JOIN
cw b ON a.bhcw = b.bh LEFT OUTER JOIN
FLFP c ON a.flfpmz = c.bh AND a.lb = '门诊' LEFT OUTER JOIN
FLFP D ON a.flfpzy = D.bh AND D.lb = '住院'
WHERE (a.mc = '1')
ORDER BY a.lb, a.BH