I made a query but the result is not correct.  What could be the problem.  The result is showing records from people that have records in the file com_leden

Paul,

It's perhaps an issue with the precedence of the boolean operators AND and OR.
Try to add parenthesis to the expression, it might help you making it more readable and make clear in what order shall the various expressions be evaluated.
It's hard to tell you exactly how to do it as I have no idea about what would you consider a correct result.
Also, in future please be gentle and post the sql in text format and not as an image

--
Fernando Dias
[Team Elevate]

Paul


Have you tried breaking the query down into its components and checked if they all work separately? I've always found it useful to test out the individual chunks in DBSys before combining them.

Roy Lambert [Team Elevate]