MySQL – Selecting data from multiple tables all with same structure but different data

by

I think you’re looking for the UNION clause, a la

(SELECT * from us_music where `genre` = 'punk')
UNION
(SELECT * from de_music where `genre` = 'punk')

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. INNER JOIN ON vs WHERE clause
  3. Join vs. sub-query
  4. 1052: Column ‘id’ in field list is ambiguous
  5. Subqueries vs joins
  6. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  7. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  8. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  9. MySQL: GROUP_CONCAT with LEFT JOIN
  10. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  11. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  12. Difference between left join and right join in SQL Server [duplicate]
  13. SQL Join Differences
  14. MySQL not using indexes with WHERE IN clause?
  15. SQL: Find the max record per group [duplicate]
  16. Group by month and year in MySQL
  17. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  18. Maintaining order in MySQL “IN” query
  19. MySQL: What is a reverse version of LIKE?
  20. Select only rows by join tables max value
  21. MySQL select where column is not empty
  22. Laravel join with 3 Tables
  23. Renaming foreign-key columns in MySQL
  24. MySQL GROUP BY behavior
  25. SQL server join tables and pivot
  26. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  27. Update multiple rows with one query?
  28. Is NATURAL (JOIN) considered harmful in production environment?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment