> If you join table A with table B and return only A columns, > you will get as many A rows as there are rows in B.
I was too fast, correction: If you join table A with table B and return only A columns, you will get as many rows as there are (A,B) tuples produced by the join and some rows might be duplicate. Milosz