USP_SALESORDER_GETPATRONDELIVERYINFO

    create procedure dbo.USP_SALESORDER_GETPATRONDELIVERYINFO
    (
      @CONSTITUENTID uniqueidentifier
    )

    as
    begin
      select 
        A.ID, 
        P.ID, 
        E.ID
      from dbo.CONSTITUENT as C
      right outer join dbo.ADDRESS as A
      on C.ID = A.CONSTITUENTID and A.ISPRIMARY = 1
      left outer join dbo.PHONE as P
      on C.ID = P.CONSTITUENTID and P.ISPRIMARY = 1
      left outer join dbo.EMAILADDRESS as E
      on C.ID = E.CONSTITUENTID and E.ISPRIMARY = 1
      where C.ID = @CONSTITUENTID
    end