Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Union Query
- Thread starter aarellano
- Start date
two tables that have only one filed that is equal. and bring in all the fields
Have a look here:
Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
Have a look here:
Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
Although a UNION is often portrayed as a type of join, it is not one that depends on any type of record matching among the tables being UNIONed. The only requirements are that there must be the same number of fields in each SELECT and corresponding fields must be of the same data type.
From your description, you may want to look at outer joins in the reference that PHV gave you.
From your description, you may want to look at outer joins in the reference that PHV gave you.
- Status
Similar threads
- Locked
- Question
