Advertisement
Guest User

Untitled

a guest
Nov 19th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.30 KB | None | 0 0
  1. SELECT cust.Name AS NomeCliente, prod.Name AS NomeProduto, TX_DESCRICAO AS Quantidade
  2. FROM Sale
  3. INNER JOIN Customer AS cust
  4.                 ON cust.CD_CUPOM = APP_INDICACAO.CD_CUPOM_DESCONTO_ANFITRIAO
  5. INNER JOIN SEG_USUARIO AS prod
  6.         ON prod.CD_USUARIO = CD_USUARIO_ANFITRIAO
  7.         WHERE CD_INDICACAO= 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement