Member Avatar for lifeworks

hi

i have two tables, one is products, the other is for 'discounts' on those products... when adding a new 'discount' i want to avoid adding two discounts to a single product... so i was looking for some sort of Right Join which would exclude all products which have a match in the discount table?!

Ill be using a 'select' to choose a product to add a discount to... the query needs to output all product name without a corresponding discount entry...

any ideas?

lworks

  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by lifeworks
Member Avatar for pritaeas

Something like this:

select * from product where id not in (select product_id from discount)
Member Avatar for lifeworks

nice one! worked great.

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.