SELECT DISTINCT MASTREL_MASTER AS MasterNo,MASTREL_RELNO AS RelationNo,REL_FULLNAME AS Name ,CONVERT(VARCHAR,REL_DOB,106) AS DateOfBirth,REL_MOTHER AS MotherName,REL_UNIQUEID1 AS PassportNo ,REL_UNIQUEID2 AS DrivingLicenceNo,REL_UNIQUEID3 AS TINNo,REL_UNIQUEID4 AS PhotoIdNo,REL_UNIQUEID5 AS Others ,ADDRESS_ADDRESS AS Address,CONTACT_CONTACT AS Contact,FATHERSPOUSE_FATHER AS FatherName,FATHERSPOUSE_SPOUSE AS SpouseName FROM t_AspMastRel LEFT OUTER JOIN t_AspAcc ON t_AspMastRel.MASTREL_MASTER=t_AspAcc.ACC_MASTER LEFT OUTER JOIN t_AspRel ON t_AspMastRel.MASTREL_RELNO=t_AspRel.REL_RELNO LEFT OUTER JOIN t_AspContact ON t_AspContact.CONTACT_RELNO=t_AspMastRel.MASTREL_RELNO LEFT OUTER JOIN t_AspAddress ON t_AspAddress.ADDRESS_RELNO=t_AspMastRel.MASTREL_RELNO LEFT OUTER JOIN t_AspFatherSpouse ON t_AspFatherSpouse.FATHERSPOUSE_RELNO=t_AspMastRel.MASTREL_RELNO INNER JOIN (SELECT DISTINCT REL_RELNO AS RELNO FROM t_AspRel WHERE REL_RELNO='********') AS TBL ON t_AspMastRel.MASTREL_RELNO=TBL.RELNO WHERE MASTREL_RELNO='********'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)