Can we use CONCAT and JOIN together in MySQL? [closed]

by

Yes you can. Try something like this:

SELECT a.ID, CONCAT(a.name,' ',b.surname) AS FULL_Name
  FROM table_a a JOIN table_b b
    ON a.ID = b.ID

See this SQLFiddle

More Related Contents:

  1. NOT LIKE not working with SHOW [duplicate]
  2. Get top n records for each group of grouped results
  3. Joining three tables using MySQL
  4. Join tables with SUM issue in MYSQL
  5. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  6. MySQL Orderby a number, Nulls last
  7. Troubleshooting “Illegal mix of collations” error in mysql
  8. sql joins as venn diagram
  9. How should I store GUID in MySQL tables?
  10. How to perform a mysqldump without a password prompt?
  11. MySQL, better to insert NULL or empty string?
  12. MySQL indexes – what are the best practices?
  13. Selecting random rows with MySQL
  14. How to remove leading and trailing whitespace in a MySQL field?
  15. How to reset the root password in MySQL 8.0.11?
  16. How does MySQL CASE work?
  17. What characters have to be escaped to prevent (My)SQL injections?
  18. How to save MySQL query output to excel or .txt file? [duplicate]
  19. MySQL: Set user variable from result of query
  20. Is there a naming convention for MySQL?
  21. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  22. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  23. How to swap values of two rows in MySQL without violating unique constraint?
  24. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  25. Would it help to add index to BIGINT column in MySQL?
  26. MySQL: set field default value to other column
  27. CREATE command denied to user？
  28. What is the MAX number if I store int(255) in MySQL?
  29. How to initialize mysql container when created on Kubernetes?
  30. Auto-increment is not resetting in MySQL

Leave a Comment