More SELECTS - my brain hurts

[rseigel]

Thanks to everyone that's helped so far. I have another one I can't wrap my head around:

 

I'm using:

SELECT * FROM tmp_BF, ps_product WHERE tmp_BF.wholesale_price != (SELECT wholesale_price
FROM ps_product) AND tmp_BF.wholesale_price = ps_product.wholesale_price

I'm trying to find products that are in both tables where the wholesale price doesn't match.

 

I realize I should be trying to use a JOIN - just not sure how to handle it.

 

Any hints?

 

Thanks,

 

Ron

[Barand]

I am guessing that the key to join on is supplier ref, as per your last post.

SELECT *
FROM tmp_BF
INNER JOIN ps_product USING (supplier_referance)
WHERE tmp_BF.wholesale_price <> ps_product.wholesale_price

[rseigel]

Thanks very much, That works perfectly.

 

There's a LOT to learn.....