Ane ada tabel kayak gini gan...

| id_jadwal | kode_jadwal | tanggal | id_detil_kegiatan |
-------1------------- 001-------2013-02-22----------1-------------
-------1------------- 001-------2013-02-25----------1-------------
-------1------------- 001-------2013-02-29----------1-------------
-------2--------------002-------2013-02-22----------2-------------
-------3--------------005-------2013-02-28----------3-------------
-------3--------------005-------2013-02-30----------3-------------

Mau ane buat jadi kayak gini

| id_jadwal | kode_jadwal | tanggal | id_detil_kegiatan |
-------1------------- 001-------2013-02-22----------1-------------
-------2--------------002-------2013-02-22----------2-------------
-------3--------------005-------2013-02-28----------3-------------

Gmn querynya yah?? Mohon pencerahan