S
subs
carrier price year
op 3333 2009
ot 233 2009
table B
Carrier price year
op 1200 2008
op1 1400 2008
i need a JOIN query which can give me the following data( by combining
the
tables)- left join or right join but it should combine all the data
from both tables irrespective of whether the joined fields are equal
or not
Carrier price for 2009 price for 2008
op 3333 1200
ot 233 -
op1 - 1400
op 3333 2009
ot 233 2009
table B
Carrier price year
op 1200 2008
op1 1400 2008
i need a JOIN query which can give me the following data( by combining
the
tables)- left join or right join but it should combine all the data
from both tables irrespective of whether the joined fields are equal
or not
Carrier price for 2009 price for 2008
op 3333 1200
ot 233 -
op1 - 1400