IPS SQL queries

gistfile1.txt

--/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
SELECT *
  FROM [Building].[dbo].[Complaint] c
  join [Building].[dbo].[Inspection] i
  ON c.transaction_to_property_id = i.transaction_to_property_id
  WHERE c.complaint_number = 'CU2014-0050'
 
--/api/business_license/payment_data/complaint_id
SELECT *
from Building.dbo.Complaint c
join Building.dbo.Payment p
on c.transaction_to_property_id = p.transaction_to_property_id
Where complaint_number = 'CU2014-0050'

--/api/permit_application/application_number 

--/api/permit_record/permit_number

--/api/permit_record/inspections/permit_number