How do I combine the results of two queries with ordering?

by

You can use UNION ALL to get rows from both tables:

SELECT id, article, author, tag, date FROM table1 WHERE tag = '1'
UNION ALL
SELECT id, article, author, tag, date FROM table2 WHERE tag = '3'
ORDER BY date

You may also want to consider restructuring your database so that instead of using two tables you use just a single table with a field to distinguish the type of each row. Then the query can simplify to:

SELECT id, article, author, tag, date
FROM yourtable
WHERE (tag, type) IN (('1','type1'), ('3','type2'))
ORDER BY date

More Related Contents:

  1. Complex Count in MySQL
  2. Using column alias in WHERE clause of MySQL query produces an error
  3. How do I query between two dates using MySQL?
  4. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. Using union and order by clause in mysql
  7. Using an Alias in SQL Calculations
  8. Can a table field contain a hyphen?
  9. MySQL JOIN the most recent row only?
  10. Can MySQL replace multiple characters?
  11. OUTPUT Clause in MySQL
  12. Search all columns of a table using a single where condition with single keyword in mysql
  13. What does SQL clause “GROUP BY 1” mean?
  14. Using ORDER BY and GROUP BY together
  15. Sorting by date & time in descending order?
  16. Case statement in MySQL
  17. MySQL Pivot Table Column Data as Rows
  18. updating columns with a sequence number mysql
  19. MySQL, Concatenate two columns
  20. Select a column with a keyword name
  21. MySQL: Inner join vs Where [duplicate]
  22. Syntax error when using except in a query
  23. Selecting from two tables with inner join and limit [duplicate]
  24. Use Composite Primary Key as Foreign Key
  25. Why the order of evaluation for expressions involving user variables is undefined?
  26. sql like operator on integer
  27. How to select data where a field has a min value in MySQL?
  28. How to SELECT by MAX(date)?
  29. The best way to remove value from SET field?
  30. get a recursive parent list

Leave a Comment