hi, g lg binggung. g puya 2 tabel PEGAWAI =>PGW_ID,NAMA,ALAMAT ACCOUNT =>ID,PASS,PGW_ID,STATUS;
kedua tabel dihubungkan oleh field PGW_ID. trus g ingin menampilkan di pop list, nama pegawai yang belum memiliki account. kira2 query nya gimana yah? g coba dengan query : SELECT A.NAMA FROM PEGAWAI A,ACCOUNT B WHERE NOT (A.PGW_ID = B.PGW_ID); tapi hasilnya ngaco. pake cara non equijoin(<>) juga gagal. please ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
