gistfile1.sql

-- Et forsøk på å hente ut 
select o.object_userid as "Unit",
       userid(a.cb_id)     as "CB"
       ,userid(c.cb_id)     as "CB2"
       
       
       from 
                objrep o
                left join objecttobusbar a on (a.object_id = o.object_id)
                left join objecttobusbar c on (c.object_id = o.object_id) 
                
       
       WHERE
       o.object_type = 'UNIT'
       AND a.cb_id <> c.cb_id
       ;