Guest User

Untitled

a guest
Jun 24th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. SELECT table1.id, GROUP_CONCAT(table2.values)
  2. FROM table1
  3. INNER JOIN
  4. table2
  5. ON FIND_IN_SET(table2.id, table1.nos)
  6. GROUP BY
  7. table1.id
  8.  
  9. SELECT table1.id, GROUP_CONCAT(table2.values),GROUP_CONCAT(table2.values)
  10. FROM table1 INNER JOIN table2 ON
  11. FIND_IN_SET(table2.id, table1.nos),
  12. INNER JOIN table2 ON
  13. FIND_IN_SET(table2.id, table1.nos1),
  14. GROUP BY table1.id
  15.  
  16. id: no nos1
  17.  
  18. 1 14,15,16 17,18
  19.  
  20. id value
  21.  
  22. 14 PHP
  23. 15 JAVA
  24. 16 C++
  25. 17 mysql
  26. 18 mysql server
  27.  
  28. id no nos1
  29.  
  30. 1 PHP, JAVA, C++ mysql, mysql server
  31.  
  32. SELECT table1.id,
  33. (
  34. SELECT GROUP_CONCAT(table2.values)
  35. FROM table2
  36. WHERE FIND_IN_SET(table2.id, table1.no)
  37. ) AS no,
  38. (
  39. SELECT GROUP_CONCAT(table2.values)
  40. FROM table2
  41. WHERE FIND_IN_SET(table2.id, table1.nos1)
  42. ) AS nos1
  43. FROM table1
Add Comment
Please, Sign In to add comment