RE: [sqlite] Error when matching column names in a view

2006-03-28 Thread Joe Wilson
hments. > > Thank you. > > -Original Message- > From: Boris Popov [mailto:[EMAIL PROTECTED] > Sent: Friday, March 24, 2006 4:16 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Error when matching column names in a view > > Any comments would be app

Re: [sqlite] Error when matching column names in a view

2006-03-28 Thread Martin Jenkins
NOTICE This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that is private and confidential. If you have received it in error, please notify the sender and delete the entire message including any attachments. Thank you. -Or

RE: [sqlite] Error when matching column names in a view

2006-03-28 Thread Boris Popov
e including any attachments. Thank you. -Original Message- From: Boris Popov [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 4:16 PM To: sqlite-users@sqlite.org Subject: [sqlite] Error when matching column names in a view Any comments would be appreciated, SQLite version 3.3.4 En

[sqlite] Error when matching column names in a view

2006-03-24 Thread Boris Popov
Any comments would be appreciated, SQLite version 3.3.4 Enter ".help" for instructions sqlite> create table one (id integer primary key); sqlite> create table two (id integer primary key); sqlite> select one.id, two.id from one join two where one.id=two.id; sqlite> create view three as select one.