Skip to content

Instantly share code, notes, and snippets.

@rodrigobravo

rodrigobravo/sqlite.sql

Created September 21, 2017 16:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rodrigobravo/bdc75ac1717efbf9a54f7ac4ef0fb7c4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rodrigobravo/bdc75ac1717efbf9a54f7ac4ef0fb7c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sqlite.sql
select DET.ID,
DET.DOCHEADER_ID,
DET.line_number,
DET.description,
DET.qnt,
DET.qnt_base,
DET.qnt_delivered,
DET.pending_qnt,
DET.price,
DET.discount1,
DET.discount2_add,
DET.discount2_mul,
DET.adjustment,
DET.discount_value,
DET.total,
DET.gross_total
FROM DOCMOVDETAIL DET
WHERE DET.DOCHEADER_ID = "553032908538289265"
JOIN DOCHEADER DHE on DHE.ID = DET.DOCHEADER_ID
ORDER BY 1,2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment