I did some thing like this:

```
with q1 as 
( 
  select x, count(*) as A from T1 where .. condition group by x
 ),
q2 as ( select x, count(*) AS B  from T2 where .. condition group by x),
q3 as ( select x, count(*) AS C from T3 where .. condition group by x),
Q4 AS ( select x, count(*) AS D from T4 where .. condition group by x)

SELECT Q1.X, Q1.A, Q2.B, Q3.C, Q4.D FROM Q1,Q2,Q3,Q4 

```

I only get blank results.. also i'm passing date as input arguments for each select. 
column x exists in 4 different tables. All i have to do is show the count of x from each table for a particular date range.