Re: Finding rows in table A which do not have a match in table B

> >[...] But your proposed result does not show a row of A.
>
> [...] Please clarify what you actually want.
>
> Sincerely,
>
> Gene Wirchenko

Gene,

My apologies for mis-typing the example data. The DATE in the result set should have been the value from table A. Despite that, a couple of solutions were provided, at least one of which worked perfectly (I did not try the solution provided by Bob Stearns).

-Dave H. Received on Thu Oct 12 2006 - 22:18:46 CEST