SQL help need

[kbasha2004]

Hi All,

I need to display the value  of QTY_4QTR data for PRIOR YEAR Quarter in the report.
Suppose if the user select year 2009, then the prvious year 2008 last quarter values should be displayed = "209" from table QTY_4QTR.

Table 1 -Year, Qrt
-----------------------       
1970 ,Q1 
1970 ,Q2 
1970 ,Q3 
1970 ,Q4
1971 ,Q1
1971 ,Q2
1971 ,Q3
1971 ,Q4 
1972 ,Q1 
1972 ,Q2 
1972 ,Q3 
1972 ,Q4
.. .. ,
.. ... ,
2008 ,Q1 
2008 ,Q2 
2008 ,Q3 
2008 ,Q4 
2009 ,Q1
2009 ,Q2 
2009 ,Q3 

Table 2 --   QTY_4QTR
-------------------------------
100
123
134
465
657
921
85
4566
38
102
94
7689
567
.....
....
103
405
667
209
408
289
567


Thanks in Adv,

kbasha2004

[VisioX]

Why don't you combine these to tables into a new one on your databse? Would make it easier.