I have run into a very simple query. Since I rarely do SQL programming, I am asking this query. I have results returned from two queries. I need to get the aggregate of the second column. Sample query is as follows :create table emp1(name varchar(100), age int)create table emp2(name varchar(100), age int)insert into emp1values('Jacob',25)insert into emp1values('Jacob',75)I want the result to be :Name : Jacob Age : 100Please help.