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)