samedelstein

--/api/business_license/application_data/complaint_id
SELECT *
  FROM [Building].[dbo].[Complaint] c
  left outer JOIN [Building].[dbo].[User_Defined_Action] uda
  ON c.complaint_id = uda.parent_id
  left outer JOIN [Building].[dbo].[User_Defined_Action_Type] udat
  ON uda.user_defined_action_type_id = udat.user_defined_action_type_id
  WHERE c.complaint_number = 'CU2014-0050'
 
--/api/business_license/inspection_data/complaint_id