Re: Compare lookup

[Peter Brawley]

> the syntax alludes me

That'd be neat, you mean 'eludes' :-)

> If one the durations is not matching its peers for a result to return
> with all materialID on each location with the discrepancy under duration.

Unclear. You mean do not report materialIDs for which durations are identical, otherwise report all per-materialID durations?

For a materialID where all durations are identical, count(distinct duration)=1. So it seems you want ...

select materialID, group_concat(duration)
from locations
group by materialID
having count(distinct duration)>1;