I am somewhat of a SQL newbie. My question is how would I go about creating a query that searched for things like:
1. users who have collected a complete set of promo items
2. users who have purchased every movie from actor X
3. users who have purchased every item less than $10

Any assistance would be greatly appreciated.

do not expect us to guess and solve your problem.

Please post the structure of your tables.

Oh my apologies for not being clear with what I was curious about. I was asking in a more generic sense, simply to try to understand some of SQL's syntax. There is no actual database as of yet.

However, I am discovering that it is difficult to discuss database topics without an actual database.

you need to pass the condition in the where clause of the query as per your requirement.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.