Monday, November 8, 2004, 11:27:11 AM, you wrote:
p> 2)
p> SELECT
p> A.TGL,
p> B.NO_TELP,
p> B.NM_PEL,
p> C.NM_REGU
p> FROM KONSELING A
p> RIGHT join M_PELANGGAN B
p> on A.NO_TELP=B.NO_TELP
p> inner join M_REGU C
p> on B.REGU=C.KD_REGU
p> WHERE A.TGL IS NULL
p> nb:
p> field tanggal seharusnya kan kosong,
p> karena belum pernah telepon
Sori ... !!
Maksud saya Menampilkan yang pd tgl 01/01/04 belum menelpon,
sebab bisa jadi tgl 02/01/04 semua lengkap menelpon .. dan tgl
03/01/04 ada lagi yang gak nelpon ...
tapi yg ingin ditampilkan adl tgl 01/01/04.
Thank's
--
Best regards,
Fikri mailto:[EMAIL PROTECTED]
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
