SQL問題 |
尚未結案
|
vivi666666
初階會員 發表:83 回覆:94 積分:35 註冊:2003-03-05 發送簡訊給我 |
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 '
|
ko
資深會員 發表:28 回覆:785 積分:444 註冊:2002-08-14 發送簡訊給我 |
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 來做條件 搜尋
------
====================== 昏睡~ 不昏睡~ 不由昏睡~ |
本站聲明 |
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇! |