Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT cust.Name AS NomeCliente, prod.Name AS NomeProduto, TX_DESCRICAO AS Quantidade
- FROM Sale
- INNER JOIN Customer AS cust
- ON cust.CD_CUPOM = APP_INDICACAO.CD_CUPOM_DESCONTO_ANFITRIAO
- INNER JOIN SEG_USUARIO AS prod
- ON prod.CD_USUARIO = CD_USUARIO_ANFITRIAO
- WHERE CD_INDICACAO= 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement