Artikel ini akan membahas Bagaimana Query JOIN, LEFT JOIN, RIGHT JOIN, dan FULL JOIN.
Perhatikan Tabel-tabel berikut:
Tblbarang
idbarang
|
namabarang
|
harga_barang
|
jenis_barang
|
supplier
|
1
|
Spidol ABG
|
4500
|
1
|
1
|
2
|
Buku Leces
|
1200
|
1
|
2
|
3
|
Sepatu ABC
|
54000
|
2
|
3
|
4
|
Mie Instan
Rasa Jahe
|
2400
|
3
|
4
|
5
|
Mie Instan
Rasa Jengkol
|
2500
|
3
|
4
|
6
|
Sepatu Nike
|
225000
|
2
|
5
|
7
|
Tas NIke
|
75000
|
4
|
5
|
8
|
Celana Bata
|
10000
|
5
|
3
|
9
|
Spidol BG
|
5000
|
1
|
1
|
10
|
Buku Sekolah
|
1500
|
1
|
2
|
11
|
Mie Instan
Rasa Jelly
|
2500
|
3
|
4
|
12
|
Football
Shoes
|
112500
|
2
|
5
|
13
|
Celana Basket
|
50200
|
5
|
5
|
14
|
Pena Snowman
|
3000
|
1
|
1
|
15
|
Penghapus
Snowman
|
Like this:Like Loading...
Related
|