>>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!

Based on your question, you have to use the one with the "OR" clause.