CODEWITHSUNDEEP
mysqlsql
gagah gelap
gagah gelap

Reputation: 83

query 2 record in 1 line

I have two table like below:

Table "peg":

|  id  |  name  |  kode  |
--------------------------
|  P01 |  david | 101    |

Table "absen":

|  kode |  time               |  ket |
----------------------------------------
|  101 |  2018-01-25 07:00:00 | IN   |
|  101 |  2018-01-25 16:00:00 | OUT  |

Please help me how to get the query result as below:

|  id  |  name  | kode |      time_1          | ket| time_2             | ket |
-------------------------------------------------------------------------------
|  P01 |  david | 101  |  2018-01-25 07:00:00 | IN |2018-01-25 16:00:00 |OUT  |

Upvotes: 2

Views: 54

Answers (1)

Blue
Blue

Reputation: 22911

Here is an example sqlfiddle. You can do 2 left joins (Aliasing the absen table), to get your result:

SELECT peg.*, ab1.time as time_1, ab1.ket as ket, ab2.time as time_2, 
ab2.ket as ket2  FROM peg
LEFT JOIN absen ab1 ON peg.kode = ab1.kode AND ab1.ket = 'IN'
LEFT JOIN absen ab2 ON peg.kode = ab2.kode AND ab2.ket = 'OUT'

Upvotes: 4

Related Questions