Member Avatar for daniyalnawaz

hi,
i have two entities products and categories. both have many-to-many relation. how can i get the products that are not related with the categories. i mean the ones which not not mapped in junction table.

thank you!
daniyal nawaz

  • 3 Contributors
  • 2 Replies
  • 101 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by varmadba
Member Avatar for pritaeas 
SELECT * FROM products WHERE product_id NOT IN (SELECT DISTINCT product_id FROM junction_table)
Member Avatar for varmadba

Try this :

select products .*,junction_table.product_id from products 
left outer join junction_table
  on junction_table.product_id=products .product_id
having junction_table.product_id is null
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.