Thanks, that is a good workaround. Is this a bug or a "feature?"
On 7/24/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
SQLite is having trouble resolving loans.book_id without an alias... SELECT * FROM books LEFT OUTER JOIN ( select loans.book_id LBID from users JOIN loans ON users.name = loans.user_name ) ON books.id = LBID; --- Jonathan Ellis <[EMAIL PROTECTED]> wrote: > Not sure what's wrong with this SQL; it works fine with postgresql: > > sqlite> SELECT * FROM books LEFT OUTER JOIN (users JOIN loans ON users.name= > loans.user_name) ON books.id = loans.book_id; > SQL error: no such column: loans.book_id
