Union Clause 
Author Message
 Union Clause

When the union clause is used to get the combined result of two queries,
SQL automatically removes duplicate
rows and returns distinct rows. How can I use the Union while also
getting all rows. Note that same rows all
belong to one query i.e. it is not possible that a row from the first
query is equivalent to a row from the second
query.

Mansoor

Sent via Deja.com http://www.***.com/
Before you buy.



Mon, 30 Sep 2002 03:00:00 GMT
 Union Clause

Mansoor,

UNION ALL?

--
Tibor Karaszi, Cornerstone Sweden AB
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Please reply to the newsgroup only, not by email.


Quote:

> When the union clause is used to get the combined result of two queries,
> SQL automatically removes duplicate
> rows and returns distinct rows. How can I use the Union while also
> getting all rows. Note that same rows all
> belong to one query i.e. it is not possible that a row from the first
> query is equivalent to a row from the second
> query.

> Mansoor

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Mon, 30 Sep 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. UNION clause in View Designer

2. UNION Clause unsupporter?

3. UNION Clause Question

4. Having Union clause in a view

5. UNION Clause?

6. UNION clause questions

7. Help : Order by with Union clause

8. Creating a view with union clause

9. Parameterised queries and UNION clause

10. Union Clause help needed

11. UNION clause syntax question

12. ACCESS : ADOX and views with UNION clause


 
Powered by phpBB® Forum Software