How to access same name table fields in table join using db_fetch_object I've SNO in both A and B tables.

I do  

db_query('SELECT * from A JOIN B on A.SNO=B.SNO')


Now how do I access both SNO fields of A and B using db_fetch_object?
You should name your fields in the SELECT, then you can use AS to rename them to something clearer:

SELECT fielda, fieldb, A.SNO AS thisone, B.SNO AS thatone, FROM... etc