Advertisement
martinsluis

CLIENTES CONTATOS

Nov 20th, 2019
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.29 KB | None | 0 0
  1. SELECT
  2.     C.CLI_NOME,
  3.     C.CLI_TELEFONE_1,
  4.     C.CLI_TELEFONE_2,
  5.     C.CLI_FAX_1,
  6.     C.CLI_CELULAR_1
  7.  
  8. FROM
  9. CLIENTES C
  10.  
  11. WHERE C.CLA_CODIGO <> 'OFF'  AND (
  12.         C.CLI_TELEFONE_1 <> '' OR
  13.         C.CLI_TELEFONE_2 <> '' OR
  14.         C.CLI_FAX_1 <> '' OR
  15.         C.CLI_CELULAR_1 <> '')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement