dear senior
langsung aja ya, minta advise.
bagaimana penulisan syntax oracle berikut
bila di SQL SERVER.
sudah baca BOL nya SQL server tapi salah melulu.
========= berikut bila di oracle ==============================
UPDATE TWDAY RST
SET IN_TIME = ( SELECT MAX( CHECK_TIME )
FROM TWTEXT TXT
WHERE TXT.EMP_NO = RST.EMP_NO
AND TXT.WK_DAY = :ls_date
AND TXT.STATUS = 0
AND EXISTS ( SELECT 'X'
FROM TWDAY DAY
WHERE DAY.WK_DAY = TXT.WK_DAY
AND DAY.EMP_NO = TXT.EMP_NO
)
GROUP BY EMP_NO
)
WHERE WK_DAY = :ls_date
AND EXISTS ( SELECT 'X'
FROM TWTEXT TXT
WHERE TXT.EMP_NO = RST.EMP_NO
AND TXT.WK_DAY = :ls_date
AND EXISTS ( SELECT 'X'
FROM TWDAY DAY
WHERE DAY.WK_DAY = TXT.WK_DAY
AND DAY.EMP_NO = TXT.EMP_NO
)
) ;
=============================================
RST adalah nama alias.
trimakasih banyak untuk advisenya.
regards
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
