E
Edward
Hi Everybody,
To explaian my question i need to give a simple example : I have a query
with three fields first name,last name and code
in code field we can have 4 different codes (A,B,C,D)
in the final query I might have a specific person (e.g. John Brown ) with
multiple entries with different codes
John Brown D
...
John Brown B
....
John Brown C
....
John Brown B
....
John Brown B
my goal is to show all the people who dont have code "A" in any of the
records. In my example John Brown wouldd be a qqualified person because he
doesnt have code "A" in any of the records. I just need to show his name once
not multiple times.
so my desired out put should be
JOhn Brown <--- just once
As a secodn question lets assume John brown has code "A" in one of the
records , how should I write the query to not show his name in my output ?
Thanks,
To explaian my question i need to give a simple example : I have a query
with three fields first name,last name and code
in code field we can have 4 different codes (A,B,C,D)
in the final query I might have a specific person (e.g. John Brown ) with
multiple entries with different codes
John Brown D
...
John Brown B
....
John Brown C
....
John Brown B
....
John Brown B
my goal is to show all the people who dont have code "A" in any of the
records. In my example John Brown wouldd be a qqualified person because he
doesnt have code "A" in any of the records. I just need to show his name once
not multiple times.
so my desired out put should be
JOhn Brown <--- just once
As a secodn question lets assume John brown has code "A" in one of the
records , how should I write the query to not show his name in my output ?
Thanks,