SELECT * FROM AHMMOERP_DTLSETTINGS JOIN AHMMODCM_TXNPRMMCHS ON VWCTID = VITEMNAME