Hi
I have just started using the Doa components
3.3.1
In my oracle DB, I have
a) Person table
- Names and
- 2 addresses links to Table Address
b) Address Table
- Id
- Full address
I am using OracleDataset,with
- SQL = select a.*,a.rowid,b.id prid,b.addrname praddress, c.id peid,c.addrname peaddress from person a,address b, address c where a.presentaddress=b.id and a.permanentaddress = c.id;

Then I use the delphi db edit controls.
However on Insert, It gives an error that the column name is wrong. I think it could be that I an renaming the b and c columns. But how else can I distinguish the field names to assign to my db Controls.

If I use the following code for SQL, the column names from b and c are repeated in the result.
select a.*,a.rowid,b.*,c.*
from person a,address b, address c where a.presentaddress=b.id and a.permanentaddress = c.id;