>select distinct a.id from a,b,c where a.id = b.id or a.id = c.id

A third way to do it. Cool. Between these three I outta be able to adapt one to exactly what I need, which is a more complicated version of the problem I stated.

Thanks!