select * from table1 left join table2 on table1.part_id = table2.part_idwhere table2.part_id is null
On 4/16/07, asnan khusaini <[EMAIL PROTECTED]> wrote: > > 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? [Non-text portions of this message have been removed] -- 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/
