CODEWITHSUNDEEP
phpmysqlsql
user3886782
user3886782

Reputation: 21

Two where in one query

A have query: "SELECT date, COUNT(id) FROM leads WHERE userkey = '$userkey' GROUP BY DAY(date)"

I want add second where is_lead 1

Example:

[FIRST]

SELECT date, COUNT(id) FROM leads WHERE userkey = '$userkey' GROUP BY DAY(date)

[SECOND]

SELECT COUNT(price) from leads WHERE userkey = '$userkey' and is_lead = 1

Union not work.

Please Help!

Upvotes: 1

Views: 70

Answers (1)

catalinetu
catalinetu

Reputation: 660

or you want to do this?

SELECT a.userkey,DATE, COUNT(id),b.countp 
  FROM leads a
  LEFT JOIN (SELECT COUNT(price) AS countp 
        FROM leads 
        WHERE userkey = '$userkey' AND is_lead = 1) b
    ON a.userkey=b.userkey
WHERE userkey = '$userkey' 
GROUP BY DAY(DATE)

Upvotes: 2

Related Questions