Program pencarian data mahasiswa bimbingan konseling STAIN Bukittinggi dalam data base SQL Server.
select B.nim,C.nama,B.kode,A.nama,C.kelas
from matakuliah A inner join krs B
on A.kode = B.kode
inner join mahasiswa C
On B.nim = C.nim
where B.tahun= '2010/2011' and left (C.nim,2)='26' and A.kode='26.2.27.2'
order by C.nim asc
