> Being really pedantic I can not be silent for the fact that one letter
> aliases is considered a bad practice. Use two letters at least.

OK.

select aaaaaa.field1, aaaaaa.field2, bbbbbb.fieldfrombbbbbb ;
from table1 aaaaaa ;
inner join table2 bbbbbb on bbbbbb.somefield=aaaaaa.somefield;
where aaaaaa.field1="X"

Golly. That's a lot clearer. ;-)