SELECT
SC.SCAT_CAT_ID
,C.CAT_NAME
,SC.SCAT_NAME
,AP.STS_NAME
,CAT_CREATED_DATE
,CAT_MODIFIED_DATE
,CAT_FEATURED
FROM
Category C
INNER JOIN SubCategory SC ON C.CAT_ID=SC.SCAT_CAT_ID
AND C.CAT_IS_ACTIVE=SC.SCAT_IS_ACTIVE
INNER JOIN AppStatus AP ON SC.SCAT_IS_ACTIVE= AP.STS_IS_ACTIVE
---------------it will produces the result set, which contains matched rows only-------------