To Combine all data from 2 tables

From: Sri (anonymous_at_discussions.microsoft.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 06:45:01 -0800

Hi All,

I have 2 tables of Sales data , one for 2004 yr and the
second for 2005 yr(Jan & Feb)..

I want to combine these tables into one showing all the
data from 2 tables..but not just combining..but showing
the info for a particular product continuously instead of
splitting..

I can't use the relationships to match the data since from
2005, a product may be dropped or introduced..using
relationships, those products will be ignored..

Eg.

Table 1
product Jan04 feb04 Mar04...
A 15 14 16
B 10 12 13
C 9 8 7

Table 2
product Jan05 feb05
A 10 20
B 12 15
D 40 50

The output what i look for is...

Output
product Jan04 feb04 Mar04...Jan05 feb05
A 15 14 16 10 20
B 10 12 13 12 15
C 9 8 7
D 40 50

The output should combine together relevant information
and show it together and also show any information that
are not related..

I have used UNION ALL operator to do this, but it just
returns as a bunch,,duplicating the products per table..

Does anyone know how to do this...Its very urgent, i have
to finish asap..

Thanks in advance for your help..

Have a nice day..

Sri

Relevant Pages

  • Re: Outlook Contacts
    ... You left out most of the relevant information. ... showing up, in what view, and in what version of Outlook? ... "Rick Williams" wrote in message ... > For some reason the addresses are not showing up unless I click on the ...
    (microsoft.public.outlook.contacts)
  • Re: win98 outgoing connections
    ... >>> Please post meaningful, relevant information on how someone elses logs, showing ...
    (comp.security.misc)
  • Re: Cantor Confusion
    ... That is a void assertion unless you can prove it by showing that ... element by which the union differes from all the lines. ... For linear sets you cannot help yourself by stating that the diagonal ...
    (sci.math)
  • Re: Cantor Confusion
    ... showing that element by which the union differes ... For linear sets you cannot help yourself by stating ...
    (sci.math)
  • Re: Union IIF statement
    ... Never mind it's not exactly what I want, ... Overall to show up last I ended up showing it first in the column by changing ... >> Now that I got this working how do I set the order of the Union by the ...
    (microsoft.public.access.queries)