You are reading a single comment by @itsbruce and its replies.
Click here to read the full conversation.
-
I also can't program
Understanding how databases behave is a whole separate discipline to programming. A large number of programmers are largely or entirely ignorant of the subject. A depressing number of them have a dismissive attitude even to SQL, which reveals them to be a lot dumber than they realise. The good ones have a reasonable grasp, but it's a specialist subject and in larger enterprises often an entirely distinct discipline.
itsbruce
I also can't program (unless you count smashing bits of VBA together) but it looks like there are three sequential parts to the query - could you add a condition to the second two to ignore any records found in the preceding part(s)?