Jim Lawrence
accessd at shaw.ca
Sat Jan 19 12:56:56 CST 2008
DISTINCT is only not available when you are using with the ORDER BY clause within the same statement. In the case of a UNION query, it would not be necessary to use DISTINCT as it provides the same functionality. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Saturday, January 19, 2008 7:18 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Combine two tables Is DISTINCT available to a union query? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik Sent: Saturday, January 19, 2008 7:13 AM To: Access Developers discussion and problem solving Subject: [AccessD] Combine two tables Hi, everybody, In an Access 2002 I have two linked tables, table A is in the BE which belongs to this FE, table B is in a different database, and it is used there as well. Both tables are lists of persons with id, lastname, firstname, and other fields. I want to use names from both tables as customers. I have made a union query, but this gives me duplicate id numbers. Is there a way to insert the source table name into the union query, so that I can then distinguish from which table a certain record is? Or is there a better solution? Thank you Lembit -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.7/1232 - Release Date: 1/18/2008 7:32 PM -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com