{ Berbagi, Menulis, Dan Mengajar } Ilmu… » 4. Programming / IDE, MYSQL » Inner Join
Inner Join
(3:36:16 PM) dimas_4dityo: boss…INNER JOIN Kie piye ??
(3:36:22 PM) dimas_4dityo: pengertian konsep e
(3:37:25 PM) punyadony: nggabungno dua tabel.. penggabungane, berdasar ndek field key yg bersesuaian ndek masing2 tabel
(3:37:52 PM) punyadony: tabel A : NIP, Nama, Alamat
(3:38:11 PM) punyadony: tabel B : NIP, Gaji, Bonus
(3:38:21 PM) punyadony: nah join e
(3:39:31 PM) punyadony: select a.nama, a.alamat, b.gaji, b.bonus from A a inner join B b on a.NIP = b.NIP
(3:40:01 PM) dimas_4dityo: oo…
(3:40:05 PM) dimas_4dityo: oke2x
(3:40:29 PM) punyadony: ok2
Filed under: 4. Programming / IDE, MYSQL