ollyjackson/gist:319416

Created March 2, 2010 10:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ollyjackson/319416.js"></script>
Save ollyjackson/319416 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

gistfile1.txt

select i.id, sum(li.value) as litotal from invoice as i ,line_items as li where li.invoice_id = i.id group by li.invoice_id having litotal > 0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment