USP_PARTIALINFORMATIONSEARCHRESULT_BODETAIL_RELATIONSHIPS_SELECT

create procedure dbo.USP_PARTIALINFORMATIONSEARCHRESULT_BODETAIL_RELATIONSHIPS_SELECT(
    @ID uniqueidentifier
)
as
begin
    select
        R.MATCHFLAG,
        R.LASTNAME,
        R.FIRSTNAME,
        R.MIDDLENAME,
        R.SUFFIX,
        R.TITLE,
        R.FULLNAME,
        R.YEAROFBIRTH,
        R.GENDERCODE,
        R.ADDRESS1,
        R.CITY1,
        R.STATE1,
        R.ZIP1,
        R.ADDRESS2,
        R.CITY2,
        R.STATE2,
        R.ZIP2,
        R.LASTDATE
    from
        dbo.PARTIALINFORMATIONSEARCHRESULT_BODETAIL_RELATIONSHIPS R
    inner join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL BOD on BOD.ID = R.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where
        BOD.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @ID

end