> How can I avoid using aliases if my query is returning two columns
> with the same name from two different tables?

SELECT A.NAME, B.NAME
FROM A
JOIN B ON ...

All fields will be referred to internally by their full table
qualified name. In your Fields* definitions you have something
like...

A.NAME=A Name
B.NAME=B Name

If you need to hook these one of these fields to a control you do
it with the full table qualified name.


--
Geoff Worboys
Telesis Computing