jagroop · December 1, 2017 05:22
diff --git a/query.sql b/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
	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