TABLE name is BY_DESC data如下 CUSTNO,ITEM,KIND,NO,TYPE 11000,1,A,A001,A 11000,2,A,A001,A 11000,3,A,A002,B 11000,4,A,A002,B 11000,5,A,A002,B 11001,1,A,A003,A 11001,2,A,A003,A 11001,3,A,A003,A 11001,4,A,A004,B 11001,5,A,A004,B 取11000,A001,A002即CUSTNO,NO,NO(不同TYPE取出NO) 11001,A003,A004 如何下SQL select custmer,(SELECT DISTINCT NO FROM BY_DESC WHERE KIND='A' AND TYPE='A') AS NO, (SELECT DISTINCT NO FROM BY_DESC WHERE KIND='A' AND TYPE='B') AS NO 我下以下SQL會出現''results in more than one column having same name. Column name 'NO' is specified more than once '

vivi666666 你好: select a.CUSTNO ,(select no from BY_DESC as b where a.CUSTNO=b.CUSTNO and KIND='A' AND TYPE='A') as NO1 ,(select no from BY_DESC as b where a.CUSTNO=b.CUSTNO and KIND='A' AND TYPE='B') as NO2 from BY_DESC as a //-- 若有特殊需求要用group by 來做 可在 group by後面在用having 來做條件 搜尋

------
======================
昏睡~
不昏睡~
不由昏睡~