Re: Group By with condition

I'm not totally clear on your requirement but would the HAVING keyword
solve the problem? That's kind of like a WHERE but in the group by phase of
the query..

SELECT fld1, fld2, fld3, fld4 FROM tblTable1
INNER JOIN ............
GROUP BY fld1, fld2, fld3, fld4
HAVING fld4='TL'

On Thu, May 21, 2015 at 3:14 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
wrote:

> Let´s suppose I have the following query:
>
> SELECT fld1, fld2, fld3, fld4 FROM tblTable1
> INNER JOIN ............
> GROUP BY fld1, fld2, fld3, fld4
>
> What I need is to group by "fld4" if and only if its value is "TL". If its
> value is different than "TL" then no grouping should be performed on this
> field.
>
> I will very much appreciate ypur feedback.
>
> Respectfully,
> Jorge Maldonado
>