> -----Original Message----- > From: Andrew Piskorski [mailto:[EMAIL PROTECTED] > Sent: 28 February 2005 17:28 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ticket 1147 > > On Mon, Feb 28, 2005 at 05:05:37PM -0000, Tim Anderson wrote: > > > SELECT Name, Title, Books.ID, Authors.ID FROM Books inner > join Authors > > on Books.AuthorID = Authors.ID ORDER BY Authors.Name, Books.Title;
> Well, that looks like correct behavior to me. If you wanted > the column to be called something different you should have > done "... Authors.ID as Authors_ID" or something like that in > your query. So if these various db interface layers need special features > from SQLite in order to rewrite those column names Not quite. You wanted the column called "Books.ID" so that was specified. Is it unreasonable to then expect to retrieve it as "Books.ID"? More important, this used to work, so 3.1.3 broke code. No big deal IMO but annoying. Tim