Show who hasn't sold

pablovicente

Hi i'm running a query like this:

select sales_representative , sum(if(product_id = '3535',1,0)) from sales group by sales_representative

That will give me how much of a given product a sales rep. sold, but i want to know how to list the sales reps. that haven't sold anything yet i think that i can use my sales reps table but i don't know how to make it.
I try:
select saler from sales_reps, sales
where sales_reps.saler != sales.sale_representative group by
saler

but didn't work any idea?

thanks!

dgrinberg

If I understand your schema what you should be using is a NOT

SELECT saler
FROM sales_reps, sales
WHERE NOT (sales_reps.saler = sales.sale_representative)
GROUP BY saler

Try that!

HTH

pablovicente

No, that don't work same result as with mine one.

ultraslacker

SELECT saler
FROM sales_reps LEFT OUTER JOIN
sales ON sales_reps.saler = sales.sale_representative WHERE sale_representative IS NULL;

piersk

Why not have an extra field in the sales_representative table called, for example, has_sold and populate it with a zero or null at beginning, then update it with a 1 when they have sold something. That way you only need to check to see if that field is a 1 to and if it is then you know that they have sold something.