Isn't ID the field INNER JOIN uses to combine the tables... That means you have to columns named ID but theire content is the same.
Bernhard ----- Original Message ----- From: "Jakub Adamek" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, February 26, 2005 10:43 PM Subject: [sqlite] Version 3.1.3 is a headache > Hi, I really love SQLite, but upgrading to 3.1.3 was not a good idea. I > have already posted 3 tickets with rather serious problems with column > names. > > The last one is really annoying and I can't believe the auto-tests could > have missed it ... > > create table a (id, x); > create table b (id, y); > insert into a values (1,1); > insert into b values (1,2); > select * from a inner join b; > > column names returned: id,x,id,y How am I supposed to use such > column names? Ouwey. No wonder that my C++ wrapper does not want to work > with such a result set. >