Untuk cari part_id yang belum ada pemiliknya ( di tabel2 ) :
Select * from tabel1 where part_id not in (select part_id from tabel2)
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?
please help me
-: newbie :-
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
[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/
