Tuesday, May 31, 2016

INNER JOIN IN SQL

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'

No comments:

Post a Comment