> > select distinct o.mud_name oil_co,
> > s.lsd,
> > s.date_started,
> > m.mud_name
> >
> > from sites s

...

> Your select list is odd in that it has a DISTINCT and then
> a series of simple field references. That probably makes
> sense in your application but I don't know that it's legal
> SQL. I'd expect to see that done with a GROUP BY...

There are no aggregate functions, so it is o.k.

Ivan