Results 1 to 2 of 2
Thread: How do I write this query?
Jun 1, 2011, 21:00 #1
How do I write this query?
I'm trying to put a query together, but my brain is failing me. Here's the simplified version of my schema;
For a given organisation, I want to find the note category/subcategory combinations that the organisation DOESN'T have.
For example, 'Smith Industries' might have notes about Pie/Baking, but no notes about Cheese/Disposal or Cheese/Production. So for 'Smith Industries', I want the output 'Cheese/Disposal' and 'Cheese/Production'.
All note categories and subcategories are already known and defined, i.e. users can't invent them on the fly.
Any help appreciated, this is confusing the hell out of me.
Jun 1, 2011, 21:49 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 52 Post(s)
- 2 Thread(s)