Grouping

[simon4amiee]

Huge problem and am baffled,

All I need to do is show just 2 lines for a person to summarize, I dont need to know a person have multiple samples, I just need to know if a person has had samples using 2 ID's, as they will then need to merged!


Example Table below

Name PersonID SampleID

Simon Evans 1234567 Sample1

Simon Evans 9999999 Sample1
Simon Evans 9999999 Sample2
Simon Evans 9999999 Sample3
Simon Evans 9999999 Sample4
Simon Evans 9999999 Sample5

 

[DCrake]

You need to group by employee by sample in your query