ato begini:
select master.kode, master.tgl, transaksi.harga,
transaksi.jumlah from master,transaksi where
master.kode=transaksi.kode
klo mo tiga tabel, misal tabel 1 lagi customer table
jadi begini:
select master.kode, master.tgl, transaksi.harga,
transaksi.jumlah,customer.nama from, transaksi, customer where
master.kode=transaksi.kode and transaksi.kodecustomer=customer.kode
-banyak table jg bisa di JOIN asal ada konektornya/id yang mo di join, OK-
-Selamat Mencoba-
-Andreas Sulistiyo-
Lilis Suryani <[EMAIL PROTECTED]> wrote:
gini mas,
select master.kode, master.tgl, transaksi.harga,
transaksi.jumlah from master inner join transaksi on
master.kode=transaksi.kode
salam
lis
__________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
---------------------------------
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games.
[Non-text portions of this message have been removed]
