Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH EvidenceIds (EvidenceID) AS
- (SELECT DISTINCT EvidenceID
- FROM unity.[Document] AS Document_1 INNER JOIN
- unity.DocSetMember ON Document_1.ID = unity.DocSetMember.DocumentID
- WHERE unity.DocSetMember.DocSetID = 13)
- SELECT *
- FROM EvidenceIds e INNER JOIN
- unity.Evidence ON ID = e.EvidenceID LEFT OUTER JOIN unity.Custodian ON Evidence.CustodianID = unity.Custodian.ID
- LEFT OUTER JOIN unity.Corpus ON unity.Custodian.CorpusID = unity.Corpus.ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement