SELECT CAST(t1.id as TEXT) + ':' + CAST(t2.id as TEXT) AS id, ...

 
Just wondering what is delimiter helpful for? Just to recognize t1.id and t2.id later on?

Petr