Tr this:
SELECT LM.eCPPatientDMG_Key
FROM tbl_eCPLedger_Master LM INNER JOIN tbl_eCPLedger_Payer LP ON LM.eCPLedger_Payer_Key = LP.eCPLedger_Payer_Key
WHERE UPPER(LP.eCPLedger_Payer_ID) = 'SELF' and LM.eCPAccount_Key='0481843194'
It should do the work!
I'd suggest to read about
joins[
^].
Here is a very interesting article which shows the differences between joins:
Visual Representation of SQL Joins[
^]