2009/12/3 Simon Davies <simon.james.dav...@googlemail.com>: > 2009/12/3 Yuzem <naujnit...@gmail.com>: >>> SELECT a.id,a.title,a.rating,tag.tag FROM (movies natural left join >>> user) as a natural left join tag; >>> >> It doesn't work, it says: no such column a.id >> If I use movies.id I have the same problem as before: movies with no rating >> don't get any tags. >> > > This is what I see: > > C:\>sqlite3 yuzem.db > SQLite version 3.4.2 > Enter ".help" for instructions . . . > sqlite> SELECT a.id,a.title,a.rating,tag.tag FROM (movies natural left join > user > ) as a natural left join tag; > 1|movie1|rating1|tag1 > 2|movie2|rating2|tag2 > 3|movie3||tag3 > sqlite> > > Regards, > Simon >
Simpler still: SELECT id,title,rating,tag FROM (movies natural left join user) natural left join tag; Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users