4/13    Question for the sql  gods:  problem: There is an output of a
        rather complicated piece of sql that that lists grpid as one of the
        columns. People prefer to see the GroupName which exists in another
        table along with grpid. The original command involves a count
        and a group by which means that adding a where will not work
        since it will  change the results. Looking thru the sql
        cookbook yielded nothing useful --newbie sql qa guy
        \_ Subselect?
        \_ Join the table with the GroupName and add GroupName to the group by
           clause.