Advertisement
Guest User

Untitled

a guest
May 27th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.53 KB | None | 0 0
  1.  
  2. WITH EvidenceIds (EvidenceID) AS
  3. (SELECT     DISTINCT EvidenceID
  4. FROM         unity.[Document] AS Document_1 INNER JOIN
  5.                       unity.DocSetMember ON Document_1.ID = unity.DocSetMember.DocumentID
  6. WHERE     unity.DocSetMember.DocSetID = 13)
  7.  
  8. SELECT *
  9. FROM        EvidenceIds e INNER JOIN
  10.                      unity.Evidence ON ID = e.EvidenceID LEFT OUTER JOIN unity.Custodian ON Evidence.CustodianID = unity.Custodian.ID
  11.                      LEFT OUTER JOIN unity.Corpus ON unity.Custodian.CorpusID = unity.Corpus.ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement