Greg At ACD escreveu:

>First try:
>
>SELECT M.*
>FROM TableMaster M
> INNER JOIN TableChild C ON M.MID = C.MID
>WHERE C.SomeValue IN (A, B)
>
>
>

I'm not completely sure but, I believe what you want is
simple that:

SELECT M.*
FROM TableMaster M
WHERE Exists ( SELECT *
FROM TableChild C
WHERE M.MID = C.MID
AND C.SomeValue IN (A, B) )


Ivan.