I have an inner join query that not's pulling the data that I need. It needs to pull one record where the int = 14 in the tblOnlineAAPAdjusters table. But it's pulling all the record id's that have joined by vchConfirmNum and vchPaymentNum. How can I get it to pull that one value?
from tblAAPPayment p
join tblOnlineAAPAdjusters a on a.vchConfirmNum = p.vchPaymentNum
where a.intID = '14'