As of now, a Service request contains parts from 4 tables (ServiceRequest, ServiceRequestAttribute, LinkedRequestSource, LinkedProductSource).


A Service Request has 1 row in ServiceRequest, 1 row in LinkedProductSource, and multiple in ServiceRequestAttribute and LinkedRequestSource.


DECLARE @serviceRequestId AS uniqueidentifier;
SET @serviceRequestId = '';

SELECT * FROM [coordinator].[ServiceRequest] WHERE [Id] = @serviceRequestId;

SELECT * FROM [coordinator].[LinkedProductSource] WHERE [ServiceRequestId] = @serviceRequestId;

SELECT * FROM [coordinator].[ServiceRequestAttribute] WHERE [ServiceRequestId] = @serviceRequestId;

SELECT * FROM [coordinator].[LinkedRequestSource] WHERE [ServiceRequestId] = @serviceRequestId;