SHARE
TWEET

Untitled

a guest Jun 25th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Tabela1 = rec  Campo = chvbfj(34)               <- codigo do cliente.(um resultado 34)  
  2. Tabela1 = rec  Campo = doc(18468, 19444...)     <- lista de codigos de itens do cliente
  3. Tabela2 = vndB Campo = chvvnda(18468, 19444...) <- tem o codigo de itens do cliente  
  4. Tabela2 = vndB Campo = chvps(600)               <- codigo da descrição  
  5. Tabela3 = ps   Campo = chvps(600)               <- tem o codigo da descrição  
  6. Tabela3 = ps   Campo = Desc(escova, lixa...)    <- descricao do codigo
  7.      
  8. SELECT *
  9. FROM rec
  10. INNER JOIN vndB ON rec.doc = vndB.chvvnda
  11. INNER JOIN ps ON vndB.chvps = ps.chvps
  12. WHERE chvbfj = 34 --código pesquisado
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top