table joins

  • Thread starter Thread starter subs
  • Start date Start date
S

subs

in access joins - i have atable which has 2009 data and another table
that has 2008 data. when i combine these tables, i need to do a join
which can give me both 2008 and 2009 data.
in one of the joins i get that data which is available in both tables
in another join, i get that the data that is available in 2008 data
but not in 2009
in another join i get the data that is in 2009 but not in 2008

is there any way by sql query or something where i can combine all the
three scenarios above

for ex

table A

carrier price year
op 3333 2009
ot 233 2009


table B

Carrier price year
op 1200 2008
op1 1400 2008


i need a query which can give me the following data( by combining the
tables)-

Carrier price for 2009 price for 2008
op 3333 1200
ot 233 -
op1 - 1400


Thanks for the help
 
Why do you have separate table for each year? That is BAD.
Use MGFoster union query to put into single table.

To get the output you asked for use MGFoster union query to feed a crosstab
query.
 
Back
Top