Subject Re: Master-Detail query help, please... :)
Author Greg At ACD
--- In, hobbit <hobbit@l...> wrote:
> SELECT distinct(M.*)
> FROM TableChild C
> JOIN TableMaster M ON M.MID = C.MID
> WHERE C.SomeValue IN (A, B)
> Gary

Thx, Gary!

The problem with SELECT distinct(M.*) is that it is very slow since
all columns in M will be considered when evaluating distinctness (is
that even a word??).

If I could do
SELECT distinct(M.MID), M.*
then we might be OK, but DISTINCT always works on the full set of