Aliases in SQL

Hi,

I have a query which contains alias like this

RP_BANK_MVA b1,
RP_BANK_MVA b2,
RP_BANK_MVA b3,

then in condition i check

bso.SETTLEMENT= b1.BANK_CODE
AND b1.FLAG = 0
AND bso.HANDLING= b2.BANK_CODE
AND b2.FLAG = 0
AND bso.OWNING= b3.BANK_CODE
AND b3.FLAG = 0


if i use the same b1 instead of b2 and b3 what will happen.I am thiniking why to have 3 aliases.
Please tell me

If you use only one table in the where clause as in:

bso.SETTLEMENT= b1.BANK_CODE
AND bso.HANDLING= b1.BANK_CODE
AND bso.OWNING= b1.BANK_CODE
AND b1.FLAG = 0

Then your query will only return rows where bso.SETTLEMENT, bso.HANDLING, and bso.OWNING are all the same number.