I have a two queries that I joined together with UNION ALL to do a count one for mobile leads and the other for web leads. But not exactly sure how to join the two results into one. Here is my query:

```
  SELECT CAST( submitdate AS DATE ) as submitdate, COUNT( DISTINCT name, email, phone, `make` , `model` , `mdlyr` , `miles` ) AS webcount FROM leads WHERE email <> '' and mobile = '0' GROUP BY CAST( submitdate AS DATE )

  UNION ALL

  SELECT CAST( submitdate AS DATE ) as submitdate, COUNT( DISTINCT name, email, phone, `make` , `model` , `mdlyr` , `miles` ) AS mobilecount FROM leads WHERE email <> '' and mobile = '1' GROUP BY CAST( submitdate AS DATE )

```

But my results are two columns that says submitdate, webcount and the dates are duplicated and with counts next to them like this:

```
  submitdate | webcount
  2014-03-19 | 30
  2014-03-19 | 15
  2014-03-18 | 59
  2014-03-18 | 37

```

When I am trying to get it to look like this:

```
  submitdate | webcount | mobilecount
  2014-03-19 | 30       | 15
  2014-03-18 | 59       | 37

```

What am I doing wrong?