Lembit Soobik
lembit.dbamail at t-online.de
Sat Jan 19 09:50:33 CST 2008
Thanks Arthur, and its easier than my solution. should have thought of that. Lembit ----- Original Message ----- From: "Arthur Fuller" <fuller.artful at gmail.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Saturday, January 19, 2008 4:39 PM Subject: Re: [AccessD] Combine two tables > The simplest way to do this is to embed the table name as a literal in > both > queries: > > SELECT CustomerID, CustomerName, "Table1" FROM somewhere > UNION > SELECT CustomerID, CustomerName, "Table2" FROM somewhere > > hth, > Arthur > > On 1/19/08, Susan Harkins <ssharkins at gmail.com> wrote: >> >> Lembit, the duplicate id values aren't really the problem, right? You >> need >> to identify the source table -- is this correct? >> >> Susan H. >> >> >> > 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 >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > -- > 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: > 18.01.2008 19:32 >