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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trying to join two queries without having duplicate entries
At the moment the statement I have is fairly simple: SELECT [Qry_Business Addresses].*, [Qry_Home Addresses].* FROM [Qry_Business Addresses], [Qry_Home Addresses] WHERE ((([Qry_Business Addresses].[Contact ID])<>[Qry_Home Addresses].[contact ID])); Now when I run it, it gives me output without...- slb818
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Trying to join two queries without having duplicate entries
I have two queries that I have created that are based off one table. One has business addresses, and one has home addresses. The contact ID field is the primary key of the table and is in both of the queries. I'm trying to build a SQL statement that pulls all the records from both queries...- slb818
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
