[AccessD] Combine two tables

no, not same name.

thanks
Lembit

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, January 19, 2008 4:45 PM
Subject: Re: [AccessD] Combine two tables


>I thought so too Arthur, but apparently, the tables have the same name --  
>is
> this correct Lembit?
>
> Susan H.
>
>
>> 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
>
> -- 
> 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
>
>