Q&A
- 파라독스에서는 서브쿼리를 못쓰나요?
안녕하세요
파라독스에서
Select M.ChongJum, M.Rank, M.Hap_CK, M.Bunho,
M.jigu, M.code, M.Name, M.hanname,
M.gyegub, M.juminno1, M.juminno2, M.sosok,
Max(M.Hak) Hak, Max(M.Hun) Hun
from (
Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
ij.jigu, gi.code, Ij.Name, ij.hanname,
ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
0 Hak, 0 Hun
from GSum Gs,Injuck Ij, gicho gi
where Gs.Kwajung = '3'
And Gs.Kisu ='154'
And Gs.Rank <='40'
And Ij.Kwajung = '3'
And Ij.Kisu ='154'
And Gs.Bunho =Ij.Bunho
And Gs.Kwajung =Ij.Kwajung
And Gs.Kisu =Ij.Kisu
And Gi.code =Ij.jigu
Union
Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
ij.jigu, gi.code, Ij.Name, ij.hanname,
ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
(Gc.Whanscore) Hak, 0 Hun
from Gscore Gc, GSum Gs,Injuck Ij, gicho gi
where Gc.Kwajung = '3'
And Gc.Kisu ='154'
and Gc.Kwacode = "01"
And Gs.Bunho =Ij.Bunho
And Gs.Kwajung =Ij.Kwajung
And Gs.Kisu =Ij.Kisu
And Gi.code =Ij.jigu
And Gc.Bunho =Gs.Bunho
And Gs.Bunho =Gc.Bunho
And Gs.Kwajung =Gc.Kwajung
And Gs.Kisu =Gc.Kisu
Union
Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
ij.jigu, gi.code, Ij.Name, ij.hanname,
ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
0 Hak, (Gc.Whanscore) Hun
from Gscore Gc, GSum Gs,Injuck Ij, gicho gi
where Gc.Kwajung = '3'
And Gc.Kisu ='154'
and Gc.Kwacode = "06"
And Gs.Bunho =Ij.Bunho
And Gs.Kwajung =Ij.Kwajung
And Gs.Kisu =Ij.Kisu
And Gi.code =Ij.jigu
And Gs.Bunho =Gc.Bunho
And Gs.Kwajung =Gc.Kwajung
And Gs.Kisu =Gc.Kisu
) as M
group By M.ChongJum, M.Rank, M.Hap_CK, M.Bunho,
M.jigu, M.code, M.Name, M.hanname,
M.gyegub, M.juminno1, M.juminno2, M.sosok
Order By M.ChongJum, M.Hak, M.Hun, M.JuminNo1 DESC
이렇게 쿼리문을 썼는데
자꾸에러가 나네요
invalid use of select
Token :select
line number:6
라는 에러거든요
저 퇴근해야 하는데 이것땜에 헤메고 있어요
빠른 답변 부탁드립니다...
파라독스에서
Select M.ChongJum, M.Rank, M.Hap_CK, M.Bunho,
M.jigu, M.code, M.Name, M.hanname,
M.gyegub, M.juminno1, M.juminno2, M.sosok,
Max(M.Hak) Hak, Max(M.Hun) Hun
from (
Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
ij.jigu, gi.code, Ij.Name, ij.hanname,
ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
0 Hak, 0 Hun
from GSum Gs,Injuck Ij, gicho gi
where Gs.Kwajung = '3'
And Gs.Kisu ='154'
And Gs.Rank <='40'
And Ij.Kwajung = '3'
And Ij.Kisu ='154'
And Gs.Bunho =Ij.Bunho
And Gs.Kwajung =Ij.Kwajung
And Gs.Kisu =Ij.Kisu
And Gi.code =Ij.jigu
Union
Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
ij.jigu, gi.code, Ij.Name, ij.hanname,
ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
(Gc.Whanscore) Hak, 0 Hun
from Gscore Gc, GSum Gs,Injuck Ij, gicho gi
where Gc.Kwajung = '3'
And Gc.Kisu ='154'
and Gc.Kwacode = "01"
And Gs.Bunho =Ij.Bunho
And Gs.Kwajung =Ij.Kwajung
And Gs.Kisu =Ij.Kisu
And Gi.code =Ij.jigu
And Gc.Bunho =Gs.Bunho
And Gs.Bunho =Gc.Bunho
And Gs.Kwajung =Gc.Kwajung
And Gs.Kisu =Gc.Kisu
Union
Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
ij.jigu, gi.code, Ij.Name, ij.hanname,
ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
0 Hak, (Gc.Whanscore) Hun
from Gscore Gc, GSum Gs,Injuck Ij, gicho gi
where Gc.Kwajung = '3'
And Gc.Kisu ='154'
and Gc.Kwacode = "06"
And Gs.Bunho =Ij.Bunho
And Gs.Kwajung =Ij.Kwajung
And Gs.Kisu =Ij.Kisu
And Gi.code =Ij.jigu
And Gs.Bunho =Gc.Bunho
And Gs.Kwajung =Gc.Kwajung
And Gs.Kisu =Gc.Kisu
) as M
group By M.ChongJum, M.Rank, M.Hap_CK, M.Bunho,
M.jigu, M.code, M.Name, M.hanname,
M.gyegub, M.juminno1, M.juminno2, M.sosok
Order By M.ChongJum, M.Hak, M.Hun, M.JuminNo1 DESC
이렇게 쿼리문을 썼는데
자꾸에러가 나네요
invalid use of select
Token :select
line number:6
라는 에러거든요
저 퇴근해야 하는데 이것땜에 헤메고 있어요
빠른 답변 부탁드립니다...
1
COMMENTS
(NOTICE) You must be logged in to comment on this post.
-
- 제덕모
- 2001.07.16 15:47
- 0 COMMENTS
- /
- 0 LIKES
-
- 초보
- •
- 2001.07.16 12:04
- 2 COMMENTS
- /
- 0 LIKES
-
하기•2001.07.16 18:37RichEdit1.Selstart := 34; RichEdit1.SelAttributes.Name := '돋움'; RichEdit1.SelAttributes.Color :=...
-
초보•2001.07.17 00:10글케 했는데도 안되네요... 쩝 Selstart에 원래 값이 대입이 안되나요? 아님 리치에디트에서 관련된 다른...
-
- 앨비니
- •
- 2001.07.16 11:22
- 1 COMMENTS
- /
- 0 LIKES
-
주삼식•2001.07.18 18:44안녕하세요. 자료실에 보면 gifimage.exe가 있습니다. 이 자료를 보면 색상을 줄이는 예제가 있습니다....
-
- 스페샬
- •
- 2001.07.16 06:43
- 1 COMMENTS
- /
- 0 LIKES
-
MAJOR•2001.07.16 19:25스페샬 wrote: > 안녕하세여. > 첨엔 별거 아닌 에러인줄 알았는데 > 도무지 해결이 안돼서여..--; > ...
-
- 강경태
- •
- 2001.07.16 04:51
- 1 COMMENTS
- /
- 0 LIKES
-
leowiz•2001.07.16 13:35델파이에서 모든 객체는 그 자체가 포인터입니다... 강경태 wrote: > 안녕하세요. > 저는 초보 개발자...
-
- allmyzzim
- •
- 2001.07.15 23:36
- 2 COMMENTS
- /
- 0 LIKES
-
leowiz•2001.07.16 13:36델파이 헬프에서 찾아보세요. 아주 자세히 나와 있습니다... allmyzzim wrote: > 움.. 공부를 하다가.....
-
allmyzzim•2001.07.16 22:18leowiz wrote: > 델파이 헬프에서 찾아보세요. 아주 자세히 나와 있습니다... > > allmyzzim wrote: >...
-
- 드기
- 2001.07.15 18:17
- 0 COMMENTS
- /
- 0 LIKES
-
- 새까만넘
- •
- 2001.07.15 17:11
- 1 COMMENTS
- /
- 0 LIKES
-
이경문•2001.07.17 09:59델파이는 wintel(windows OS계열, inter CPU계열)만 가능합니다. PDA용으로 대표적인 OS가 Windows CE가 ...
-
- 김병권
- 2001.07.15 13:04
- 0 COMMENTS
- /
- 0 LIKES
-
- 초보
- •
- 2001.07.15 07:08
- 2 COMMENTS
- /
- 0 LIKES
-
병아리•2001.07.16 08:34안녕하세요... 저도 4학년 인데여... 수업시간에 델파이를 배웠습니다. 교재는 '도서출판 대림'에서 나...
-
dbakhs•2001.07.16 18:43병아리 wrote: > 안녕하세요... > 저도 4학년 인데여... > 수업시간에 델파이를 배웠습니다. > 교재는 ...
-
- 이광무
- 2001.07.15 06:37
- 0 COMMENTS
- /
- 0 LIKES
-
- 문상연
- 2001.07.15 03:07
- 0 COMMENTS
- /
- 0 LIKES
-
- CBA
- •
- 2001.07.15 02:14
- 3 COMMENTS
- /
- 0 LIKES
-
나도초보•2001.07.15 02:18폼A.Top 폼A.Left Imple.... 그 밑에 uses 로 연결해져야대여 CBA wrote: > 폼A의 속성값을 ...
-
CBA•2001.07.15 03:09죄성하지만, ^^; 어떻게 선언해야 하는지 코드좀.... 전 완전 왕초보거든요....^^;;; 죄송하지만 어떻게 ...
-
나도초보•2001.07.15 09:23Form1과 Form2가 있다고 해보세요.. Form1에서 Form2의 Left와 Top을 알아보려면.. implementation ...
-
- 김근중
- 2001.07.15 01:26
- 0 COMMENTS
- /
- 0 LIKES
-
- 왕초보
- 2001.07.15 01:12
- 0 COMMENTS
- /
- 0 LIKES
-
- 김미연
- •
- 2001.07.15 00:39
- 1 COMMENTS
- /
- 0 LIKES
-
사발우성•2001.07.17 02:28김미연 wrote: > 여러개의 로컬 db파일들을 하나로 묻으려고 합니다.. 어케하는지 방법좀 갈켜주세요.. >...
-
- 정용광
- 2001.07.15 00:49
- 0 COMMENTS
- /
- 0 LIKES
-
- 바보
- 2001.07.15 00:34
- 0 COMMENTS
- /
- 0 LIKES
-
- 엔젤조
- •
- 2001.07.15 00:08
- 1 COMMENTS
- /
- 0 LIKES
안녕하세요 파라독스에서 Select M.ChongJum, M.Rank, M.Hap_CK, M.Bunho, M.jigu, M.code, M.Name, M.hanname, M.gyegub, M.juminno1, M.juminno2, M.sosok, Max(M.Hak) Hak, Max(M.Hun) Hun from ( Select Gs.ChongJum, Gs.Rank, Gs.Hap...-
명탁•2001.07.15 04:37엔젤조 wrote: > 안녕하세요 > 파라독스에서 > Select M.ChongJum, M.Rank, M.Hap_CK, M.Bunho, > ...
-
- 김미연
- •
- 2001.07.14 23:48
- 1 COMMENTS
- /
- 0 LIKES
-
감초•2001.07.15 14:03저장 화일 이름을 a:화일이름 으로 주심 될텐데... 김미연 wrote: > 버튼을 클릭해서 파일을 a:드라이...
> 안녕하세요
> 파라독스에서
> Select M.ChongJum, M.Rank, M.Hap_CK, M.Bunho,
> M.jigu, M.code, M.Name, M.hanname,
> M.gyegub, M.juminno1, M.juminno2, M.sosok,
> Max(M.Hak) Hak, Max(M.Hun) Hun
> from (
> Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
> ij.jigu, gi.code, Ij.Name, ij.hanname,
> ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
> 0 Hak, 0 Hun
> from GSum Gs,Injuck Ij, gicho gi
> where Gs.Kwajung = '3'
> And Gs.Kisu ='154'
> And Gs.Rank <='40'
> And Ij.Kwajung = '3'
> And Ij.Kisu ='154'
> And Gs.Bunho =Ij.Bunho
> And Gs.Kwajung =Ij.Kwajung
> And Gs.Kisu =Ij.Kisu
> And Gi.code =Ij.jigu
> Union
> Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
> ij.jigu, gi.code, Ij.Name, ij.hanname,
> ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
> (Gc.Whanscore) Hak, 0 Hun
> from Gscore Gc, GSum Gs,Injuck Ij, gicho gi
> where Gc.Kwajung = '3'
> And Gc.Kisu ='154'
> and Gc.Kwacode = "01"
> And Gs.Bunho =Ij.Bunho
> And Gs.Kwajung =Ij.Kwajung
> And Gs.Kisu =Ij.Kisu
> And Gi.code =Ij.jigu
> And Gc.Bunho =Gs.Bunho
> And Gs.Bunho =Gc.Bunho
> And Gs.Kwajung =Gc.Kwajung
> And Gs.Kisu =Gc.Kisu
> Union
> Select Gs.ChongJum, Gs.Rank, Gs.Hap_CK, Ij.Bunho,
> ij.jigu, gi.code, Ij.Name, ij.hanname,
> ij.gyegub, ij.juminno1, ij.juminno2, ij.sosok,
> 0 Hak, (Gc.Whanscore) Hun
> from Gscore Gc, GSum Gs,Injuck Ij, gicho gi
> where Gc.Kwajung = '3'
> And Gc.Kisu ='154'
> and Gc.Kwacode = "06"
> And Gs.Bunho =Ij.Bunho
> And Gs.Kwajung =Ij.Kwajung
> And Gs.Kisu =Ij.Kisu
> And Gi.code =Ij.jigu
> And Gs.Bunho =Gc.Bunho
> And Gs.Kwajung =Gc.Kwajung
> And Gs.Kisu =Gc.Kisu
> ) as M
> group By M.ChongJum, M.Rank, M.Hap_CK, M.Bunho,
> M.jigu, M.code, M.Name, M.hanname,
> M.gyegub, M.juminno1, M.juminno2, M.sosok
> Order By M.ChongJum, M.Hak, M.Hun, M.JuminNo1 DESC
> 이렇게 쿼리문을 썼는데
> 자꾸에러가 나네요
> invalid use of select
> Token :select
> line number:6
> 라는 에러거든요
> 저 퇴근해야 하는데 이것땜에 헤메고 있어요
> 빠른 답변 부탁드립니다...
inline 함수는 지원 안되요
오라클,ms-sql등등 지원되구여.