kepada rekan2 yg terhormat, saya mau ingin mengganti perintah sql dibawah ini dengan inner join . saya udah coba tapi salah terus gimana caranya ya ?
atau jika ada referensi tutorial dasar tentang inner join saya harus download dimana ?
mudah2 an ada rekan2 yang bisa membantu
terima kasih banyak ya ?
Dim strSQL As String
strSQL = "SELECT `HEAD ORDER`.`NO ORDER`, `HEAD ORDER`.TANGGAL, "
strSQL = strSQL & "PELANGGAN.`NAMA PELANGGAN`, `ORDER`.`NAMA ORDER`,"
strSQL = strSQL & "`DET ORDER`.HARGA, `DET ORDER`.JUMLAH , "
strSQL = strSQL & "OPERATOR.`NAMA OPERATOR` AS `NM OPR`, "
strSQL = strSQL & "`DET ORDER`.HARGA * `DET ORDER`.JUMLAH AS TOTAL,"
strSQL = strSQL & "`ORDER`.KOMISI * `DET ORDER`.HARGA "
strSQL = strSQL & " * `DET ORDER`.JUMLAH / 100 AS `KOMISI OPERATOR`"
strSQL = strSQL & "FROM `HEAD ORDER`, `DET ORDER`, `ORDER`, PELANGGAN,"
strSQL = strSQL & "OPERATOR WHERE `HEAD ORDER`.`NO ORDER`= "
strSQL = strSQL & "`DET ORDER`.`NO ORDER` AND "
strSQL = strSQL & "`DET ORDER`.`KODE ORDER` = `ORDER`.`KODE ORDER` "
strSQL = strSQL & "AND `HEAD ORDER`.`NO PELANGGAN` = PELANGGAN.`NO PELANGGAN`"
strSQL = strSQL & "AND `HEAD ORDER`.`KODE OPERATOR` = OPERATOR.`KODE OPERATOR`"
Apakah Anda Yahoo!?
Kunjungi halaman depan Yahoo! Indonesia yang baru!
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
