write query for get value from same table

Question

question

rahulpatil asked Nov 6, '18

suppose this is table name user with content follwing

id name m_id

1 A Null

2 B 1

3 C 1

4 D 2

write select query for output should be

id name m_id

1 A Null

2 B A

3 C A

4 D B

query select mysql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2018-11-09T15:14:29Z

Jon Crawford answered Nov 9, '18

self join, SELECT t1.id,t1.name,t2.name FROM myTable t1 JOIN myTable t2 ON t1.id=t2.m_id

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.