Re: List unique records and combine from two tables

Bob Barrows wrote on 14 mrt 2009 in microsoft.public.inetserver.asp.db:
So a join will not do what you want. You need to use a UNION query:

select field1 from table1
union
select field1 from table2

union? Damn, that's the word ;-)

Hi, Bob, does that work in the Jet engine?

<http://www.w3schools.com/sql/sql_union.asp>

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
.

Relevant Pages

  • Re: Next step in using Equivalent of a Full Outer Join
    ... second half of the union. ... from table1 left join table2 ... problem with that is it seems on becuase that would state a many to ...
    (microsoft.public.access.queries)
  • RE: where Klausel
    ... > kann mir einer sagen, wie ich einen right/left join in einer where Klausel ... CREATE TABLE #Table1 ... CREATE TABLE #Table2 ... UNION ALL ...
    (microsoft.public.de.sqlserver)
  • Re: ProCobol Outer join
    ... from Table1 A, Table2 B ... UNION for the select with the matching criteria together with a select ...
    (comp.lang.cobol)
  • Re: Display Changed Records
    ... that last clause should have been: ... -- Also use table1 values to report rows deleted from table2 ... UNION ALL ...
    (microsoft.public.sqlserver.programming)
  • Re: Create view with rows from two tables - not by joining
    ... it's not a join you want it is a union ... select A, B, C, D from Table2 ... is fine if Table1 A is the same type as Table2 B the resulting columns would ... > of A-D from table 1 or the contents of A-D from table 2. ...
    (microsoft.public.sqlserver.programming)