A union of a left and right joins should do it.
On 12/7/2010 4:50 AM, Simon Slavin wrote: > On 7 Dec 2010, at 12:37pm, Pavel Ivanov wrote: > >>> I Writed A FULL OUTER JOIN Query In Sqlite But I Got A Message Like Not >>> Supported. What Should I Do To Do This >> You should re-think once more: do you really need a full outer join? >> Maybe you can change your schema so that it was more clear and didn't >> require full outer join for querying. > Just a note that it is probably very easy to do this. You may even be able > to phrase your SELECT with an INNER JOIN without changing the schema. Pavel > is being helpful, not insulting you. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users