关于查询的问题,急急急

供参考：

用查询解决的问题思路是：
1.查询ZYDH1
tdd表中zydh1和jhk中的zydh建立关系，查询结里显示  zydh1专业名称：

SELECT TDD.SFZH, TDD.ZYDH1, jhk.ZYDH, jhk.ZYMC
FROM TDD INNER JOIN jhk ON TDD.ZYDH1 = jhk.ZYDH;

2.查询ZYDH2
tdd表中zydh2和jhk中的zydh建立关系，查询结里显示  zydh2专业名称：

SELECT TDD.SFZH, TDD.ZYDH2, jhk.ZYDH, jhk.ZYMC
FROM TDD INNER JOIN jhk ON TDD.ZYDH2 = jhk.ZYDH;

3.查询ZYDH3
 tdd表中zydh3要和jhk中的zydh建立关系，查询结里显示zydh3名称：

SELECT TDD.SFZH, TDD.ZYDH3, jhk.ZYDH, jhk.ZYMC
FROM TDD INNER JOIN jhk ON TDD.ZYDH3 = jhk.ZYDH;

4.查询ZYMC123

tdd表中SFZH和3个查询的SFZH建立关系，显示三个专业名称:

SELECT TDD.KSH, TDD.ZKZH, TDD.XM, TDD.XBDM, TDD.CSNY, TDD.ZZMMDM, TDD.SFZH, 查询ZYDH1.ZYDH1, 查询ZYDH1.ZYMC AS ZYMC1, 查询ZYDH2.ZYDH2, 查询ZYDH2.ZYMC AS ZYMC2, 查询ZYDH3.ZYDH3, 查询ZYDH3.ZYMC AS ZYMC3
FROM ((TDD LEFT JOIN 查询ZYDH1 ON TDD.SFZH = 查询ZYDH1.SFZH) LEFT JOIN 查询ZYDH2 ON TDD.SFZH = 查询ZYDH2.SFZH) LEFT JOIN 查询ZYDH3 ON TDD.SFZH = 查询ZYDH3.SFZH;

点击下载此附件