> Tampilkan data-data di Tabel ITEMIN yang
> kombinasi KODE dan JENIS nya
> tidak tercantum di tabel ITEMOUT
Sebenarnya ini terjemahan yang 'straightforward' dari logika anda
diatas:
Here's the first-cut version
...
select i.*
from itemin i
where not exists
( select o.* from itemout o
where (o.kode = i.kode) and (o.jenis = i.jenis) );
...
Try this and let me know whether it works.
Good luck,
salam,
sugi.
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Save on Coral Calcium. Get Better Health and
Stronger Bones. Seen on TV
http://www.challengerone.com/t/l.asp?cid-2805&lp=calcium2.asp
http://us.click.yahoo.com/9gf46B/EfUGAA/ySSFAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
