SELECT xx.foo
      ,xx.bar
      ,yy.baz
      ,COUNT(*) AS count
  FROM foo_table xx
      ,bar_table yy
 WHERE xx.abcd      = yy.abcd
   AND xx.asdfghjkl = yy.asdfghjkl
 GROUP BY xx.foo
         ,yy.bar
         ,yy.baz