SQL: Two select statements in one query

You can do something like this:

 (SELECT
    name, games, goals
    FROM tblMadrid WHERE name = 'ronaldo')
 UNION
 (SELECT
    name, games, goals
    FROM tblBarcelona WHERE name = 'messi')
ORDER BY goals;

See, for example: https://dev.mysql.com/doc/refman/5.0/en/union.html

Related Posts:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. SQL SELECT WHERE field contains words
  3. SQL SELECT WHERE field contains words
  4. SQL SELECT WHERE field contains words
  5. ORA-01843 not a valid month- Comparing Dates
  6. Best way to do nested case statement logic in SQL Server
  7. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  8. SQL conditional SELECT
  9. DATEDIFF function in Oracle
  10. MySQL error: Unknown column in ‘where clause’
  11. Postgresql column reference “id” is ambiguous
  12. How to order by column A and then by column B?
  13. Help me SELECT thumbnail from SQL and use
  14. how to SELECT meta values that are not null?
  15. What is a stored procedure?
  16. Unknown column in ‘field list’ error on MySQL Update query
  17. SQL Inner-join with 3 tables?
  18. Conversion failed when converting date and/or time from character string while inserting datetime
  19. MySQL create table if not exists and insert record only if table was created
  20. error, string or binary data would be truncated when trying to insert
  21. How can I do an UPDATE statement with JOIN in SQL Server?
  22. ORA-00907: missing right parenthesis
  23. Rename column SQL Server 2008
  24. Why do we need “Relationships” between tables at all?
  25. Using group by on multiple columns
  26. How to declare a variable in MySQL?
  27. Drop a temporary table if it exists
  28. How do I escape a single quote in SQL Server?
  29. ORA-00918: column ambiguously defined in SELECT *
  30. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  31. How Stuff and ‘For Xml Path’ work in SQL Server?
  32. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  33. Oracle SELECT TOP 10 records
  34. must appear in the GROUP BY clause or be used in an aggregate function
  35. How can I return pivot table output in MySQL?
  36. Compare dates in MySQL
  37. The multi-part identifier could not be bound
  38. MySQL syntax for Join Update
  39. SQLite – UPSERT *not* INSERT or REPLACE
  40. how to drop partition without dropping data in MySQL?
  41. Simple way to calculate median with MySQL
  42. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  43. Error 1046 No database Selected, how to resolve?
  44. What is it exactly a BLOB in a DBMS context
  45. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  46. Insert text with single quotes in PostgreSQL
  47. SQL Server IF NOT EXISTS Usage?
  48. How to insert date values into table
  49. Arithmetic overflow error converting numeric to data type numeric
  50. I want to use CASE statement to update some records in sql server 2005
  51. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  52. SELECT DISTINCT on one column
  53. how to remove time from datetime
  54. TSQL PIVOT MULTIPLE COLUMNS
  55. MySQL – UPDATE multiple rows with different values in one query
  56. How to create a MySQL hierarchical recursive query?
  57. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  58. Query to convert from datetime to date mysql
  59. Equivalent of Oracle’s RowID in SQL Server
  60. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  61. Best way to test if a row exists in a MySQL table
  62. Subtract one day from datetime
  63. Get current year in TSQL
  64. Is it possible to specify condition in Count()?
  65. SQL Server: Make all UPPER case to Proper Case/Title Case
  66. using sql count in a case statement
  67. How do I query for all dates greater than a certain date in SQL Server?
  68. Backup a single table with its data from a database in sql server 2008
  69. updating table rows in postgres using subquery
  70. Temporary table in SQL server causing ‘ There is already an object named’ error
  71. MySQL OPTIMIZE all tables?
  72. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  73. Is there a coalesce-like function in Excel?
  74. How do I count unique items in field in Access query?
  75. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  76. MySQL LIKE IN()?
  77. Filter data based on date in sql
  78. What is a postgres superuser
  79. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  80. SQL query to extract only the “current” wp_posts?
  81. prepare() not working
  82. How to retrieve sticky post in raw sql?
  83. How to remove in the wordpress database all posts revisions except the last three?
  84. How do I move a WordPress site to another server?
  85. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  86. $wpdb get_var issue
  87. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  88. Auto-update tables from database
  89. Inserting rows into a custom table, when plugin is activated
  90. dbDelta not creating table (yes, once more)
  91. Posts modified in the last 48 hours
  92. post id not displaying
  93. How to export 2 week’s worth of posts
  94. Nested select statements not working
  95. blank page after update my theme
  96. Insert multiple checkbox values
  97. How to get EVENT based on startday, using BETWEEN
  98. wpdb prepare without placeholder
  99. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1
  100. Deleting the MySQL database

Leave a Comment