>> 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. ;-)

LOL. Well, it's much better now <g>