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
