Help me!Help me ...!

[haibec]

Hi Guys!I have two table Member includes : ID , Name and Product includes ID,ProductID,Name,Price . Both table related by ID . Make stuation : with a Member only buy maximum are 3 product . I want query exact amount member have Product and Price >=500$

[Jack McKalling]

I don't understand, could you rephrase that?

[haibec]

I don't understand, could you rephrase that?

Example :User 1 buy three product : product1 have Price >=500$,product2 have Price >=500$,product3 have Price >=500$User 2 buy two product : product3 have Price >=500$,product4User 3 buy product5 have Price >=500$User 4 not buyI want select : How many member buy at least a Product have Price >=500$

[justsomeguy]

Try this:SELECT COUNT(DISTINCT(users.ID)) AS num FROM users, orders WHERE users.ID=orders.ID AND orders.ID>=500The field you will get back will be called "num", and should contain the number of users who have bought at least one product with a price at least 500.

[haibec]

Try this:SELECT COUNT(DISTINCT(users.ID)) AS num FROM users, orders WHERE users.ID=orders.ID AND orders.ID>=500The field you will get back will be called "num", and should contain the number of users who have bought at least one product with a price at least 500.

Yeahhhhh!Thank you very much!