Need to combine common result of two select statements
- by Anup
i have to select the common coloumns c1 ,c2,c3 from result of two sql satements.
1)
select c1, c2, c3,count(c3) from (select * from form_name
where data_created >'1273446000' and data_creazione<'1274569200')
group by c1,c2, c3 having count(c3)>1
2)
select c1, c2, c3,count(c3) from (select * from form_name
where data_created>'1272236400' and data_creazione<'1274569200')
group by c1,c2, c3 having count(c3)>2
I need to select c1,c2,c3 all same and common found in both the result of query.
how could this be done...could anyone help please?
