mps777 发表于 2013-3-9 23:10
段大哥,有新问题请教你……谢谢
效果1:
- SELECT A.*,IIF(B.品名,'两表共有','台账2没有') AS 属性 FROM [台帐1$]A
- LEFT JOIN
- [台帐2$]B
- ON A.NO=B.NO AND A.品名=B.品名
- UNION
- SELECT B.*,IIF(A.品名,'两表共有','台账1没有') AS 属性 FROM [台帐1$]A
- RIGHT JOIN
- [台帐2$]B
- ON A.NO=B.NO AND A.品名=B.品名
复制代码
效果2:
- SELECT A.*,'台账2没有' AS 属性 FROM [台帐1$]A
- LEFT JOIN
- [台帐2$]B
- ON A.NO=B.NO AND A.品名=B.品名
- WHERE B.品名 IS NULL
- UNION ALL
- SELECT B.*,'台账1没有' AS 属性 FROM [台帐1$]A
- RIGHT JOIN
- [台帐2$]B
- ON A.NO=B.NO AND A.品名=B.品名
- WHERE A.品名 IS NULL
复制代码
效果3:
- SELECT A.NO,A.品名,B.NO,B.品名,IIF(A.品名=B.品名,'共有',IIF(B.品名,'异常','台账2没有')) FROM [台帐1$]A
- LEFT JOIN
- [台帐2$]B
- ON A.NO=B.NO
- UNION
- SELECT A.NO,A.品名,B.NO,B.品名,IIF(A.品名=B.品名,'共有',IIF(A.品名,'异常','台账1没有')) FROM [台帐1$]A
- RIGHT JOIN
- [台帐2$]B
- ON A.NO=B.NO
复制代码
|