Sql, get the average on a group while escaping the where condition
===

excuse my english but nobody can answer in French ;-)

I'm doing this request : 

    SELECT AVG(tyd.price) AS avg_price, COUNT(tyd.id_product) AS cnt_id_p,     catalog.id_marchand, catalog.id_product, catalog.price AS c_price, catalog.img_src,     tyd.login AS tyd_l
    FROM catalog 
    INNER JOIN tyd ON catalog.id_marchand = tyd.id_marchand AND catalog.id_product =   tyd.id_product
    WHERE 
    tyd.login = "user1@tyd.fr"
    AND tyd.step = "0" GROUP BY catalog.id_product, catalog.id_marchand

But of course the AVG & COUNT function doesn't work because my condition where get only one lines.

What i'd like to do is still getting my unique line but get the AVG and COUNT function working. I can do it with two queries but i'd prefer do one.

I hope you'll be able to help me. 

Thanks.


