Skip to content

Instantly share code, notes, and snippets.

@jagroop

jagroop/query.sql

Last active December 1, 2017 05:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jagroop/9142eeb3e130366cd24130f3828de1c9 to your computer and use it in GitHub Desktop.
Save jagroop/9142eeb3e130366cd24130f3828de1c9 to your computer and use it in GitHub Desktop.
Download ZIP
Query
Raw
query.sql
select usr.id as user_id, first_name, last_name, bp.*, risk.* from test_type_verification as test
inner join `jbt_testeeUsers` as usr on test.user_id = usr.id
left join bp_a1c_risk_ques_2016 as bp on test.user_id = bp.user_id
left join risk_Assessment_questions_2016 as risk on test.user_id = risk.user_id
where usr.id = 133
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment