>Yes, but you know in some instances you can determine between two fields with the same name by using the table name, for example
>
>salesorders!item_id is different from items!item_id

Yes, in this case you create 2 different aliases in you SQL query and use the alias names!