Top "Union" questions

Use this tag only for questions about UNION, a keyword of the SQL language for combining the results of multiple SQL queries.

Oracle: Order by Union returning ORA-00933: SQL command not properly ended

I have an issue with using Oracle's union and order by clauses together. I have two complex queries (with sub …

oracle sql-order-by union ora-00933
How to use union all with manual value (not from another tabel)?

I want to use union all with manual value, not from another table. And the values are: |cSatuan1|cSatuan2|nkonversi| ============================= | …

sql sql-server union union-all
SQL Union All with order by and limit (Postgresql)

In the following query I get syntax error: SELECT <property1>, <property2> FROM <table1> ORDER …

sql postgresql union union-all
Drupal Views combine 2 columns into 1?

I've got two content types, both have a node title and a document attachment, the doc attachment fields are different …

drupal views union drupal-fields
mysql order by with union doesn't seem to work

Here is my query (SELECT * FROM `jokes` WHERE `flags` < 5 AND (`title` LIKE "%only three doors%" OR `joke` LIKE "%only …

mysql select sql-order-by union
Union on two tables with a where clause in the one

Currently I have 2 tables, both of the tables have the same structure and are going to be used in a …

sql union union-all
rails union hack, how to pull two different queries together

I have a query which searches two separate fields in the same table... looking for locations which are most likely …

sql ruby-on-rails ruby activerecord union
Performance Comparison: Full outer join vs Union, Union All

I have tables named: mktActualsales (SaleID, EmployeeID, PeriodID,PositionID) mktActualSalesItems(SaleItemID, saleID, Item, Quantity) mktSalesTargets(TargetID, EmployeeID, PeriodID,PositionID) mktSalesTargetItems(…

sql sql-server-2008 union full-outer-join
SQL - Identifying source table from UNION query

I'm building an RSS feed in PHP which uses data from three separate tables. The tables all refer to pages …

sql union
Union of intervals

I've got a class representing an interval. This class has two properties "start" and "end" of a comparable type. Now …

union intervals