access joins

[subs]

table A

carrier price year
op 3333 2009
ot 233 2009
op 1200 2008
op1 1400 2008


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


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


i need a join SQl Query. none of the Access Query joins work for
this
scenario i.e left or right joins. i need to get all the records
from
the original table in the output as shown above.No duplicates. pls
help

 

[Duane Hookom]

This looks like a standard crosstab query with Carrier as the Row Heading,
"Price for " & [Year] as the Column Heading, and First of Price as the value.