pagi milis :) mau nanya, misalnya aku punya tabel spt berikut : ------------------------------------ | kode | material | qty | ------------------------------------ | 1001 | a | 1 | | 1001 | b | 2 | | 1003 | a | 5 | ------------------------------------ ingin kurubah menjadi seperti dibawah ini : --------------------------------------------------- | kode | qty material a | qty material b | --------------------------------------------------- | 1001 | 1 | 2 | | 1003 | 5 | 0 | --------------------------------------------------- perintah sql nya di mysql bagaimana ya ? atau kalau misalnya mencari di paman google, keywordnya bagaimana ? demikian, terima kasih sebelum dan sesudahnya.
salam, Popo Haryadi This e-mail message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this e-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this e-mail message from your computer.