SELECT O.CODOS, O.DATAABERTURA, O.DATAFECHAMENTO, O.NRSERIE, O.FINALIZADA, O.TOTAL,
 O.SOLICITANTE, E.DESCRICAO AS EQUIPAMENTO, M.DESCRICAO AS MARCA, MD.DESCRICAO AS MODELO,
 O.CODCLIENTE, CL.NOME AS CLIENTE, O.CODCONDICAO, C.DESCRICAO AS CONDICAO, FU.NOME AS FUNCIONARIO
    FROM OS O
     LEFT JOIN EQUIPAMENTOS  E  ON (E.CODEQUIPAMENTO  = O.CODEQUIPAMENTO)
     LEFT JOIN MARCA         M  ON (M.CODMARCA        = O.CODMARCA)
     LEFT JOIN MODELO        MD ON (MD.CODMODELO      = O.CODMODELO)
     LEFT JOIN CONDICAO      C  ON (C.CODCONDICAO     = O.CODCONDICAO)
     LEFT JOIN CLIENTES      CL ON (CL.CODCLIENTE     = O.CODCLIENTE)
     JOIN      TECNICOSOS    TC ON (TC.CODOS          = O.CODOS)
     JOIN      FUNCIONARIOS  FU ON (FU.CODFUNCIONARIO = TC.CODFUNCIONARIO)