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
    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)
