[sqlite] How can I specify that a column is equal to another?

[Yuzem]

I have this:
select title,my_rating
        from movies left join  user on movies.id = user.id
        where id = 'tt0426459'
The result:
ambiguous column name: id

I could use:
select movies.id ids,title,my_rating
        from movies left join  user on movies.id = user.id
        where ids = 'tt0426459'

but I don't want to select the id

Another solution:
        where movies.id = 'tt0426459'

Is there any way to specify that movies.id  is equal to user.id so I can use
just id in my query?
Thanks in advance!
-- 
View this message in context: 
http://www.nabble.com/How-can-I-specify-that-a-column-is-equal-to-another--tp24292794p24292794.html
Sent from the SQLite mailing list archive at Nabble.com.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users