Re: [Programmer-VB] SQL: Skala Nilai

Sun, 16 Oct 2005 22:55:06 -0700

coba query ini :
 
"select a.*,b.HurufMutu from tblNilaiMHS a left outer join
tblSkalaNIlai b on a.Nilai >= b.SkalaNilai"
mudah-mudahan bisa, sorry ga' dicoba dulu
 
 
Bony
 

[EMAIL PROTECTED] wrote:

mungkin bisa pake akal2an kaya gini bro,

select a.*, min(b.mutu) as mutu
from tblNilaiMHS a
left outer join tblSkalaNilai b
on (a.nilai>=b.skalanilai)
group by a.nim, a.nama, a.nilai

moga2 membantu..

Brgds,
Lim Agus Fitrian
Finance & Logistic IT Section Head
PT. Westindo Esa Perkasa
Jl. Gaya Motor Raya No. 8 Kav. M-N
Telp : 021 - 6518775 (hunting)
Fax : 021 - 6517336
Jakarta Utara


milist MSD <[EMAIL PROTECTED]>
Sent by: [email protected]

10/17/2005 10:09

Please respond to
[email protected]
To
[email protected]
cc
Subject
[Programmer-VB] SQL: Skala Nilai





Dear all,

Mohon sumbangan ide...

Saya punya tabel Nilai Mahasiswa, dan Tabel Skala Nilai sbb:
1. tblNilaiMHS

NIM     Nama       Nilai
111     Ada        55
222     Idi        75
333     Ede        95

2. tblSkalaNilai

SkalaNilai   HurufMutu
0            F
40           E
50           D
60           C
70           B
80           A

Ingin di Join Agar mendapatkan hasil sbb :

NIM   Nama    Nilai            HurufMutu
111   Ada     55               D
222   Idi     75               B
333   Ede     95               A

SQLnya gimana ya ? Logikanya gak ketemu2 niih... Atau ada saran
laennya ???? Tolongin ya... please...

Thanks in advance,
Wassalam,
Darmawan



------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]


Yahoo! Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/Programmer-VB/

<*> 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/







Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]


YAHOO! GROUPS LINKS



Kirim email ke