SELECT
action_requests.action_requestsid,
action_requests.client_action_request_tracking_number,
action_requests.dateval,
question_catagory.description as 'question_catagory.description',
question_sub_catagory.description as 'question_sub_catagory.description',
questions.description as 'questions.description',
action_requests.date_required
FROM
action_requests
Left Join question_catagory ON question_catagory.question_catagoryid = action_requests.question_catagoryid
Left Join question_sub_catagory ON question_sub_catagory.question_sub_catagoryid = action_requests.question_sub_catagoryid
Left Join questions ON questions.questionsid = action_requests.questionsid
