2009/12/3 Pavel Ivanov <paiva...@gmail.com>: > If using "natural left join" is not a requirement for you then this > works as you expect it: > > select movies.id, title, rating, tag > from movies left join user on movies.id = user.id > left join tag on movies.id = tag.id; >
Or: SELECT a.id,a.title,a.rating,tag.tag FROM (movies natural left join user) as a natural left join tag; Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users