|Subject||Re: [firebird-support] More FB 2.0 / FB1.5 optimizer differences|
> > 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 thenThere are no aggregate functions, so it is o.k.
> 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...