Guest User

Untitled

a guest
Jun 22nd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. select b.*
  2. from (
  3. select 1 as ignore_me from dual
  4. ) a
  5. LEFT JOIN (
  6. -- your real query goes here
  7. select cc.cod_filial as filial
  8. ,cc.cod_forca_venda as forca_venda
  9. ,cl.cod_cnpj_cliente as cliente_cnpj
  10. from mdb_sgc_cliente_cresc cc
  11. ,mdb_sgc_cli cl
  12. where cc.id_cliente = cl.id_cliente(+)
  13. and cc.id_crescimento = -1 -- this parameter isn't going find anything!
  14. ) b on 1 = 1
  15. ;
Add Comment
Please, Sign In to add comment