SELECT a, b, c, d from foo, bar where foo.id = bar.id;