I have three queries :
Query1 :Returns : Empid,LName,FName,Year_1Salary.
Query2 :Returns : Empid,LName,FName,Year_2Salary.
Query3 :Returns : Empid,LName,FName,Year_3Salary.

I want final query which returns as:

QueryFinal :Returns : Empid,LName,FName,Year_1Salary,Year_2Salary, Year_3Salary.

I m working on MS Access database.
Tried Union of all three but dosen'gt give desire result any idea?

Thanks in advance.


Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

use case!
for example:

select name,
case year when 1 then YearSalary else 0 end
case year when 2 then YearSalary else 0 end
case year when 3 then YearSalary else 0 end
from
(
select name, year, YearSalary
from tableX
group by year
) t