fmbraga=# select cli.codsci, cli.n_guerra, cli.filial, cli.grupo_sci, cli.codsis, cli.cidade, cli.estado, cli.dtassinat, cli.sistema, cli.acesso, cli.oldcli, sis.codsis, sis.hd_ok, sis.tr_okdo, cli.dtassinat, cli.sistema, cli.acesso, cli.oldcli, sis.codsis, sis.hd_ok,                                                                                        fmbraga-# from inetcli cli
fmbraga-# left outer join eqxsist sis on (cli.codsis=sis.codsis)
fmbraga-# where cli.filial='SALVADOR'
fmbraga-# and substring( cli.codsci from 1 for 6) <> '009900'
fmbraga-# order by estado, n_guerra;
   codsci    |     n_guerra      |  filial  | grupo_sci | codsis |      cidade      | estado |      dtassinat      |    sistema     | acesso | oldcli | codsis | hd_ok | tr_ok
-------------+-------------------+----------+-----------+--------+------------------+--------+---------------------+----------------+--------+--------+--------+-------+-------
 11000671571 | ADRESSE           | SALVADOR | t         | SA057  | SALVADOR         | BA     | 2002-09-20 00:00:00 | SCANER         | f      | f      | SA057  | f     | f
 11000658885 | AGEFAG            | SALVADOR | t         | SA003  | SALVADOR         | BA     | 2002-08-27 00:00:00 | ANFAC          | t      | f      | SA003  | f     | f
 11000659661 | CONFAC            | SALVADOR | t         |        | SALVADOR         | BA     |                     | DIFACT/DECISAO | t      | f      |        | t     | t
 11000659661 | CONFAC            | SALVADOR | t         |        | SALVADOR         | BA     |                     | DIFACT/DECISAO | t      | f      |        | t     | t
 11000659661 | CONFAC            | SALVADOR | t         |        | SALVADOR         | BA     |                     | DIFACT/DECISAO | t      | f      |        | t     | t
 11000601620 | D ALEM MAR        | SALVADOR | t         | SA043  | SALVADOR         | BA     | 2002-08-22 00:00:00 | INFORGEL       | t      | f      | SA043  | t     | t
 11000660286 | DINIZ             | SALVADOR | t         | SA005  | SALVADOR         | BA     |                     | DIFACT/DECISAO | t      | f      | SA005  | t     | t
 11000677464 | GIRO              | SALVADOR | t         | SA005  | SALVADOR         | BA     | 2002-10-30 00:00:00 | DIFACT/DECISAO | t      | f      | SA005  | t     | t
 11000642318 | ITABUNA FACTORING | SALVADOR | t         | SA021  | ITABUNA          | BA     |                     | VENTURE        | t      | f      | SA021  | t     | t
 11000661444 | LUAUTO BAHIA      | SALVADOR | t         | SA005  | SALVADOR         | BA     | 2002-08-16 00:00:00 | DIFACT/DECISAO | t      | f      | SA005  | t     | t
 11000642288 | MAYOR             | SALVADOR | t         | SA021  | ILHEUS           | BA     | 2002-04-17 00:00:00 | VENTURE        | t      | f      | SA021  | t     | t
 11000642300 | MONEY             | SALVADOR | t         | SA021  | ILHEUS           | BA     | 2002-04-17 00:00:00 | VENTURE        | t      | f      | SA021  | t     | t
 11000668490 | PERSONAL          | SALVADOR | t         | SA050  | FEIRA DE SANTANA | BA     | 2002-09-02 00:00:00 | ANGELO         | t      | f      | SA050  | f     | f
 11000661509 | SP                | SALVADOR | t         | SA005  | SALVADOR         | BA     | 2002-08-20 00:00:00 | DIFACT/DECISAO | t      | f      | SA005  | t     | t
 11000659199 | SSA               | SALVADOR | t         | SA005  | SALVADOR         | BA     | 2002-08-22 00:00:00 | DIFACT/DECISAO | t      | f      | SA005  | t     | t
 11000660570 | TORK              | SALVADOR | t         |        | SALVADOR         | BA     |                     |                | t      | f      |        | t     | t
 11000660570 | TORK              | SALVADOR | t         |        | SALVADOR         | BA     |                     |                | t      | f      |        | t     | t
 11000660570 | TORK              | SALVADOR | t         |        | SALVADOR         | BA     |                     |                | t      | f      |        | t     | t
 11000660278 | VICTORIA          | SALVADOR | t         | SA041  | SALVADOR         | BA     | 2002-08-16 00:00:00 | VICTORIA       | t      | f      | SA041  | t     | t
 11000642296 | VIRTUAL           | SALVADOR | t         | SA021  | ILHEUS           | BA     | 2002-04-17 00:00:00 | VENTURE        | t      | f      | SA021  | t     | t
 11000677847 | VISAO             | SALVADOR | t         | SA043  | SALVADOR         | BA     | 2002-11-26 00:00:00 | INFORGEL       | t      | f      | SA043  | t     | t
 11000670630 | BRASIL            | SALVADOR | t         | SA021  | PETROLINA        | PE     | 2002-10-10 00:00:00 | VENTURE        | t      | f      | SA021  | t     | t
 11000674619 | LINS              | SALVADOR | t         | SA017  | PETROLINA        | PE     | 2002-10-16 00:00:00 | PROSIS         | t      | f      | SA017  | t     | t
 11000674724 | RIO FACTORING     | SALVADOR | t         | SA066  | PETROLINA        | PE     | 2002-10-30 00:00:00 | SOFTRIO        | t      | f      | SA066  | f     | f
 11000674627 | SAKE              | SALVADOR | t         | SA017  | PETROLINA        | PE     | 2002-10-16 00:00:00 | PROSIS         | t      | f      | SA017  | t     | t
(25 rows)