sqlite join

http://stackoverflow.com/questions/1923259/full-outer-join-with-sqlitehttp://sqlite.awardspace.info/syntax/sqlitepg06.htm

http://sqlfiddle.com/