Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT table1.id, GROUP_CONCAT(table2.values)
- FROM table1
- INNER JOIN
- table2
- ON FIND_IN_SET(table2.id, table1.nos)
- GROUP BY
- table1.id
- SELECT table1.id, GROUP_CONCAT(table2.values),GROUP_CONCAT(table2.values)
- FROM table1 INNER JOIN table2 ON
- FIND_IN_SET(table2.id, table1.nos),
- INNER JOIN table2 ON
- FIND_IN_SET(table2.id, table1.nos1),
- GROUP BY table1.id
- id: no nos1
- 1 14,15,16 17,18
- id value
- 14 PHP
- 15 JAVA
- 16 C++
- 17 mysql
- 18 mysql server
- id no nos1
- 1 PHP, JAVA, C++ mysql, mysql server
- SELECT table1.id,
- (
- SELECT GROUP_CONCAT(table2.values)
- FROM table2
- WHERE FIND_IN_SET(table2.id, table1.no)
- ) AS no,
- (
- SELECT GROUP_CONCAT(table2.values)
- FROM table2
- WHERE FIND_IN_SET(table2.id, table1.nos1)
- ) AS nos1
- FROM table1
Add Comment
Please, Sign In to add comment