Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Tabel Kategori
- ================================
- id_cat | kategory
- 1 | Makan
- 2 | Minum
- Tabel Item Sub
- ================================
- id_item_sub | nama_item_sub | id_cat
- 1.1 | Makan Enak | 1
- 1.2 | Minum Air | 2
- Tabel Sub Item
- ================================
- id_sub_item | nama_sub_item | id_item_sub
- 1.1.1 | Makan Nasi Goreng | 1.1
- 1.1.2 | Minum Air Putih | 1.2
- Query 1 : select nama_item_sub , id_cat from tabel 2 where tabel3.id_item_sub = tabel2.id_item_sub
- Hasil :
- ===================================
- JIKA,
- id_item_sub tabel 3 = 1.1
- maka data yg dapat :
- nama_item_sub | id_cat
- Makan Enak | 1
- ===================================
- JIKA,
- id_item_sub tabel 3 = 1.2
- maka data yg dapat :
- nama_item_sub | id_cat
- Minum Air | 2
- ===================================
- Query 2 : Select * from Tabel Item Sub where result.id_cat = Tabel Item Sub.id_cat
- Hasilnya :
- Jika Result.id_cat = 1
- maka data yg dapat :
- id_cat | kategory
- 1 | Makan
- ==========================
- Jika Result.id_cat = 2
- maka data yg dapat :
- id_cat | kategory
- 2 | Minum
- ==========================
- Select JOIN :
- =====================
- SELECT tbl_sub_item.`id` AS 'ID Sub Item', tbl_sub_item.`nm_sub_item` AS 'Nama Sub Item', tbl_item_sub.`id` AS 'ID Item Sub' ,tbl_kategori.`kategori` AS 'Nama Kategori'
- FROM tbl_sub_item
- JOIN tbl_item_sub ON tbl_sub_item.`id_item_sub` = tbl_item_sub.`id`
- JOIN tbl_kategori ON tbl_item_sub.`id_cat` = tbl_kategori.`id`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement