Buatlah database dengan nama dblatihan1
Dengan struktur  tabel sebagai berikut :

Tabel tbMarketing
Field
Type
Null
Key
NoID
Char(4)
No
Primary
Nama
Varchar(20)
No

NoHP
Varchar(12)
No

Alamat
Varchar(35)
No


Tabel tbJual
Field
Type
Null
Key
NoJual
Char(4)
No
Primary
NoID
Char(4)
No

TglJual
Date
No

Quantity
Smallint
No


Isikan tabel dengan data berikut :

NoID
Nama
NoHP
Alamat
M001
Nindy
08123456789
Condong Catur Yogyakarta
M002
Rayhan
08987787788
Cibeureum Bandung
M003
Yuki
08542829982
Sukabumi Jawa Barat
M004
Sunny
08174432432
Karanganom Klaten
M005
Chika
08183460990
Grogol Sukoharjo

NoJual
NoID
TglJual
Quantity
J001
M001
2011-10-10
45
J002
M002
2011-10-11
30
J003
M004
2011-10-11
15
J004
M006
2011-10-12
25

mysql> SELECT NoJual, NoID, Nama, TglJual, Quantity
-> From tbMarketing, tbJual
    -> Where tbMarketing.NoID=tbJual.NoID;

mysql> SELECT NoJual, tbMarketing.NoID, Nama, TglJual, Quantity
-> From tbMarketing, tbJual
-> Where tbMarketing.NoID=tbJual.NoID;

mysql> SELECT NoJual, tbMarketing.NoID, Nama AS Nama_Marketing,
-> TglJual, Quantity
-> From tbMarketing, tbJual
-> Where tbMarketing.NoID=tbJual.NoID

mysql> SELECT NoJual, tbMarketing.NoID, Nama, TglJual, Quantity
-> From tbMarketing, tbJual
 -> Where tbMarketing.NoID=tbJual.NoID;

Penggunaan LEFT JOIN

Mysql> select * from tbMarketing LEFT JOIN tbJual
 -> ON tbMarketing.NoID = tbJual.NoID;

Penggunaan RIGHT JOIN

Mysql> select * from tbMarketing RIGHT JOIN tbJual
 -> ON tbMarketing.NoID = tbJual.NoID;

Penggunaan NATURAL JOIN

Mysql> select * from tbMarketing NATURAL JOIN tbJual;