On 25 March 2014 14:09, Christian Dallinger <dallinger_christ...@hotmail.com> wrote: > Hello, I want to join these 3 tables from my database: > > http://pastebin.com/f8FP0G0C
something like select Macadress, timestamp, result, user, '', '', '', '' from checklog union select MacAdress, timestamp, '', '', '', error1, error2, errortext from error; union select MacAdress, timestamp, '', '', text, '', '', '' from service order by timestamp Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users