Re: [DUG]: Column Names

[Neven MacEwan]

Title: Message

Kyley   No it isn't   ''Select Store.StoreID, StoreCriteria.StoreID from Store JOIN StoreCriteria on Store.StoreID = StoreCriteria.StoreID"   is perfectly valid SQL, It stems more from the TDataSets non SQL heritage, and yes I could alias the column names but that isn't the point since the column names are unique anyway   Neven ----- Original Message ----- From: Kyley Harris To: Multiple recipients of list delphi Sent: Tuesday, October 01, 2002 5:44 PM Subject: RE: [DUG]: Column Names it is a standard SQL thing. "select Store.StoreID Store_StoreID, StoreCriteria.StoreID Crit_StoreID" naming them yourself might be more useful to you -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neven MacEwan Sent: Tuesday, 1 October 2002 1:42 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Column Names 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]