[DUG]: Column Names

[Neven MacEwan]

Hi all   TADOQuery given a query of "select Store.StoreID, StoreCriteria.StoreID from Store JOIN StoreCriteria on Store.StoreID = StoreCriteria.StoreID" ie 2 columns with the same 'name' but not will cause a fieldname of 'StoreID' and StoreID_1 is there any way to determine which is which ie is 'StoreID' Store.StoreID or  StoreCriteria.StoreID (without parsing the SQL) or is this an problem with TDataSet    Regards Neven  N.K. MacEwan B.E. E&E  Ph 649 621 0001  Fax 649 621 0400  [EMAIL PROTECTED]