On 1 Jul 2009, at 5:24pm, Yuzem wrote: > Is there any way to specify that movies.id is equal to user.id so I > can use > just id in my query?
I think you have already come up with the two best solutions. You could also create a VIEW http://www.sqlite.org/lang_createview.html and specify which 'id' you wanted when defining the view. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users