let's say table a has: table b has: ... keyword ... ... keyword ... 1 2 2 2 3 2 1) return 3 records 2) return 1 records That's diffferent between 1) and 2)