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

Reply via email to