> What query are you trying with the above tables, and how do the
> results differ from what you expect?
>
This is the query:
SELECT movies.id,title,files,icon_modified,icon_width
FROM (movies natural left join files) natural left join icons_movies
LIMIT 25 ;
The difference with your last query is that I have to specify the tables or
it says "ambiguous column name" and the problem with the result is that if a
movie doesn't have an entry in the table "files" it doesn't show the icon
properties.
--
View this message in context:
http://old.nabble.com/Multiples-natural-left-joins-problem-tp26627140p26635883.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
