Right, of course it should be a.b. Your solution is one of the options. How about simply select count( * ) from A? I'm not sure how it's going to work in more complicated cases, though.