Mysql: Select in Select : I had create two table (Table A and Table B) and try using INNER JOIN both table but the result will be in different row even the ID is same.

Is there any mysql select to extract all the value with same ID in one row as shown in 'Result' table?

[Image][1]


  [1]: https://i.stack.imgur.com/Zviw3.png