On Fri, 15 Dec 2000, you wrote: > Halo tanya, > Sebelumnya saya ucapkan terimakasih atas saran2/jawaban dari pertanyaan > terdahulu sehingga problem saya bisa terselesaikan. mysql>INSERT INTO dest SELECT DISTINCT prlama,prbaru,pr_desc from source; Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql>SELECT * FROM dest +--------+--------+---------------------+ | prlama | prbaru | pr_desc | +--------+--------+---------------------+ | KW001 | KZ002 | ELECTRICAL TOOL SET | | KW008 | KZ041 | DRILL MACHINE | | KW010 | KZ040 | MECHANICAL TOOL SET | +--------+--------+---------------------+ 3 rows in set (0.00 sec) kalo untuk semua field pake DISTINCT * Mudah-mudahan bisa membantu Salam $Fajar -------------------------------------------------------------------------------- Utk berhenti langganan, kirim email ke [EMAIL PROTECTED] Informasi arsip di http://www.linux.or.id/milis.php3 Pengelola dapat dihubungi lewat [EMAIL PROTECTED]
