Last active
August 17, 2017 12:52
-
-
Save craigboman/3f087cad09e7ce8c7e2c0baa6086f0dd to your computer and use it in GitHub Desktop.
trying to get the fund label name from sierra_view.fund
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
* | |
FROM | |
sierra_view.order_record AS o | |
JOIN | |
sierra_view.order_record_paid AS orp | |
ON | |
o.id = orp.order_record_id | |
JOIN | |
sierra_view.record_metadata AS m | |
ON | |
o.id = m.id | |
JOIN | |
sierra_view.order_record_cmf AS f | |
ON | |
o.id = f.order_record_id | |
JOIN | |
sierra_view.fund AS t | |
ON | |
f.fund_code = t.fund_code | |
WHERE | |
--m.record_num = 654887 | |
f.fund_code = '01208'--insert any local fund code here | |
; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment