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’s the best way to search for a UPC code in a Database?
  16. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  17. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  18. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  19. What is the difference between UNION and UNION ALL?
  20. Selecting COUNT(*) with DISTINCT
  21. Case in Select Statement
  22. What is a stored procedure?
  23. ORA-00904: invalid identifier
  24. SQL WITH clause example [duplicate]
  25. Unknown column in ‘field list’ error on MySQL Update query
  26. Unknown column in ‘field list’ error on MySQL Update query
  27. SQL Inner-join with 3 tables?
  28. The wait operation timed out. ASP
  29. What is SELF JOIN and when would you use it? [duplicate]
  30. The wait operation timed out. ASP
  31. Conversion failed when converting date and/or time from character string while inserting datetime
  32. Self Join to get employee manager name
  33. how to fix oracle ORA-01722 invalid number error
  34. SQL query to select dates between two dates
  35. MySQL – Operand should contain 1 column(s)
  36. Conversion failed when converting date and/or time from character string while inserting datetime
  37. When should I use CROSS APPLY over INNER JOIN?
  38. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  39. Insert Data Into Temp Table with Query
  40. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  41. SQL query to get the employee name and their manager name from the same table
  42. MySQL create table if not exists and insert record only if table was created
  43. error, string or binary data would be truncated when trying to insert
  44. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  45. NOT IN vs NOT EXISTS
  46. Online SQL Query Syntax Checker
  47. How can I do an UPDATE statement with JOIN in SQL Server?
  48. Must declare the scalar variable
  49. ORA-00979 not a group by expression
  50. ORA-00907: missing right parenthesis
  51. How do I use properly CASE..WHEN in MySQL
  52. Must declare the scalar variable
  53. Rename column SQL Server 2008
  54. Why do we need “Relationships” between tables at all?
  55. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  56. Using group by on multiple columns
  57. Efficiently convert rows to columns in sql server
  58. How can I do a FULL OUTER JOIN in MySQL?
  59. Nested select statement in SQL Server
  60. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  61. Using group by on multiple columns
  62. MySQL query String contains
  63. How do I escape a single quote in SQL Server?
  64. What’s the difference between VARCHAR and CHAR?
  65. Case statement in MySQL
  66. T-SQL split string based on delimiter
  67. How to declare a variable in MySQL?
  68. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  69. Finding duplicate values in a SQL table
  70. MySQL Cannot Add Foreign Key Constraint
  71. Drop a temporary table if it exists
  72. How do I escape a single quote in SQL Server?
  73. ORA-00918: column ambiguously defined in SELECT *
  74. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  75. How Stuff and ‘For Xml Path’ work in SQL Server?
  76. IDENTITY_INSERT is set to OFF – How to turn it ON?
  77. SQL update from one Table to another based on a ID match
  78. Oracle error : ORA-00905: Missing keyword
  79. How to split the name string in mysql?
  80. How to reset AUTO_INCREMENT in MySQL
  81. How do I import an SQL file using the command line in MySQL?
  82. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  83. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  84. mysql Foreign key constraint is incorrectly formed error
  85. How do I limit the number of rows returned by an Oracle query after ordering?
  86. Sql Server equivalent of a COUNTIF aggregate function
  87. Oracle SELECT TOP 10 records
  88. MySQL: Invalid use of group function
  89. must appear in the GROUP BY clause or be used in an aggregate function
  90. Column name or number of supplied values does not match table definition
  91. Inserting data into a temporary table
  92. Can a foreign key be NULL and/or duplicate?
  93. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  94. Why does NULL = NULL evaluate to false in SQL server
  95. How to Select Top 100 rows in Oracle?
  96. Simple PHP Pagination script
  97. How do composite indexes work?
  98. CREATE VIEW must be the only statement in the batch
  99. How can I return pivot table output in MySQL?
  100. SQL Server FOR EACH Loop

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)