title: Sqlite, join table: ambiguous column error
body: <p>I have a database and I am executing a query:</p>
  
  <pre><code>select * from 
         Exams LEFT OUTER JOIN Test on Test.tExamID = Exams.eID       
         LEFT OUTER JOIN Test on Users.userID = Test.tUserID
  </code></pre>
  
  <p>But I got an error <code>ambiguous column name main.Test.tID</code>. Have you ever seen that before? Please help me to figure out what happen.</p>
  
  <p>My database below:</p>
  
  <pre><code>    CREATE TABLE [Exams] (
        [eID] INTEGER NOT NULL PRIMARY KEY, 
        [eType] INTEGER NOT NULL, 
        [eLevel] INTEGER NOT NULL, 
        [eTime] INTEGER, 
        [eNote] CHAR);
  
  
      CREATE TABLE [Users] (
        [userID] TEXT NOT NULL, 
        [userPassword] TEXT NOT NULL);
  
      CREATE UNIQUE INDEX [userID] ON [Users] ([userID]);
  
  
      CREATE TABLE [Test] (
        [tID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
        [tUserID] TEXT NOT NULL REFERENCES [Users]([userID]), 
        [tExamID] INTEGER NOT NULL REFERENCES [Exams]([eID]), 
        [tDate] DATE NOT NULL, 
        [tScore] INTEGER NOT NULL, 
        [tNote] CHAR NOT NULL);
  </code></pre>