How would i left outer join users onto comprofiler?

Select *

from openquery(AccS_TRAINER, 'select id, firstname, lastname, address, city, state, zipcode, cb_phone, cb_cellphone from accs_comprofiler')

select
*
from openquery(AccS_TRAINER, 'select id, usertype from accs_users where usertype = "registered"')