Dear gurus,
Saya sedang membuat daftar absensi untuk 31 hari, querynya jd
panja..........ng, tulung bantu dong , query nya sbb:
SELECT A.FCKDKAR,A.NAMA,A.TGLMASUK
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')) AS S0
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+1) AS S1
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+2) AS S2
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+3) AS S3
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+4) AS S4
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+5) AS S5
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+6) AS S6
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+7) AS S7
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+8) AS S8
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+9) AS S9
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+10) AS S11
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+11) AS S12
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+12) AS S13
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+13) AS S14
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+14) AS S15
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+15) AS S16
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+16) AS S17
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+17) AS S18
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+18) AS S19
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+19) AS S20
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+20) AS S21
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+21) AS S22
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+22) AS S23
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+23) AS S24
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+24) AS S25
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+25) AS S26
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+26) AS S27
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+27) AS S28
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+28) AS S29
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('01-04-09','DD-MM-YY')+29) AS S30
,(SELECT MASUK FROM ABSENHARIAN WHERE RTRIM(FCKDKAR)=RTRIM(A.FCKDKAR) AND
TANGGAL=TO_DATE('30-04-09','DD-MM-YY')) AS S31
FROM MSKYW A
WHERE FCKDDEP=:FCKDDEP AND FCKDSEC=:FCKDSEC
[Non-text portions of this message have been removed]
