Select Code to Download

SELECT tablea.id, COUNT(*) FROM tablea, tableb
  WHERE tablea.foo = tableb.bar
  GROUP BY tablea.id

SELECT tablea.id1, tablea.id2, COUNT(*) FROM ...
  ...
  GROUP BY id1, id2