hello, I'm trying to join 2 tables, so I guess I need to perform a full outer join.
On wikipedia, I found this solution for sqlite3: http://en.wikipedia.org/wiki/Join_%28SQL%29 select * from RT0 left join RT1 on RT1.PID = RT0.PID union select RT0.*, RT1.* from RT1 left join RT0 on RT1.PID = RT0.PID where RT0.PID IS NULL Now the strange thing is that this query returns the correct number of rows, but all the columns from the employee-table are empty. If I change "UNION" to "UNION ALL" the join works as expected. Is there an explanation for this behavior ? Also when I add an order clause, the left columns are all made empty ? Is it uberhaupt possible to order the resulting table on the column PID and preferable get just 1 PID column ? thanks, Stef _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
