Kalo maksudnya mau cari part_name mana yang man_name nya kosong berarti begini : SELECT DISTINCT(tabel1.part_name) FROM tabel1,tabel2 WHERE tabel2.part_id=tabel1.part_id AND tabel2.man_name='' ORDER BY tabel1.part_id;
Kalo maksudnya mau cari part_name apa yang tidak ada di tabel2 berarti begini: SELECT DISTINCT(tabel1.part_name) FROM tabel1,tabel2 WHERE tabel1.part_id!=tabel2..part_id ORDER BY tabel1.part_id Muhadkly - Acho- , http://muhadly.info ===================================== ----- Original Message ----- From: asnan khusaini To: [email protected] Sent: Monday, April 16, 2007 10:21 AM Subject: [ITCENTER] tanya query? salam mas-mas, bapak-bapak master... bantuin ya.. saya punya 2 tabel misal tabel1 berisi part_id(pk) dan part_name; tabel2 berisi man_id(pk), part_id(fk), man_name; trus kalo qta mo ngambil part_name yang ga ada pemiliknya querynya gimana ya? please help me -: newbie :- -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/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/
