Select Distinct HeadName by INNER JOIN query:
SELECT DISTINCT HEADNM
FROM HMS_PCHGOTC A INNER JOIN HMS_HEADIO B ON A.COMPID = B.COMPID AND A.CHARGEID = B.HEADID AND B.HEADTP = 'IPD'
SELECT DISTINCT HEADNM
FROM HMS_PCHGOTC A INNER JOIN HMS_HEADIO B ON A.COMPID = B.COMPID AND A.CHARGEID = B.HEADID AND B.HEADTP = 'IPD'
No comments:
Post a Comment