Click here to Skip to main content
15,891,372 members

Comments by aminvincent (Top 6 by date)

aminvincent 10-Aug-15 20:18pm View    
in those table no relation,...finally i used this query and it worked :
SELECT IDMASUK, TANGGALMASUK, JAM, NOMERHP, ISIPESAN, NAMA
FROM PESANMASUK
LEFT JOIN KONTAK
ON KONTAK.NOHP = PESANMASUK.NOMERHP
ORDER BY TANGGALMASUK DESC, JAM DESC
aminvincent 10-Aug-15 20:17pm View    
praveen : thanks for your help,.but now i have fixed it and my query work...
this my query : SELECT IDMASUK, TANGGALMASUK, JAM, NOMERHP, ISIPESAN, NAMA
FROM PESANMASUK
LEFT JOIN KONTAK
ON KONTAK.NOHP = PESANMASUK.NOMERHP
ORDER BY TANGGALMASUK DESC, JAM DESC
aminvincent 10-Aug-15 2:25am View    
Praveen : i have tried your query above but result NAMA replace just one name,...any solution else?
aminvincent 11-Jun-15 20:57pm View    
can you give me some examples code ?
aminvincent 11-Jun-15 20:56pm View    
my problem still didn't solve,...perhaps any idea,..?