Hi rekan-rekan milis, saya punya masalah dengan SELECT
CASE QUERY
SELECT CHILD_PART,
SUM(CASE DAY(CRT_DT) WHEN 2 THEN ISS_QTY ELSE 0
END) AS TGL1 FROM TABLE
bagaimana caranya bila kondisinya 2 atau lebih
SELECT CHILD_PART,
SUM(CASE DAY(CRT_DT) WHEN 2 AND ....... THEN
ISS_QTY ELSE 0 END) AS TGL1 FROM TABLE_A
misalnya jika tanggal=1 dan bulan = ... atau
apasajalah yang penting kondisinya 2 atau lebih
ada ngga' yang tahu caranya. Tolong donk'
Atas bantuannya saya ucapkan terima kasih
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
