Skip to content

Instantly share code, notes, and snippets.

@craigboman
Last active August 17, 2017 12:52
Show Gist options
  • Save craigboman/3f087cad09e7ce8c7e2c0baa6086f0dd to your computer and use it in GitHub Desktop.
Save craigboman/3f087cad09e7ce8c7e2c0baa6086f0dd to your computer and use it in GitHub Desktop.
trying to get the fund label name from sierra_view.fund
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