asked on
Join Query
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?
Select vchRecordID
from tblAAPPayment p
join tblOnlineAAPAdjusters a on a.vchConfirmNum = p.vchPaymentNum
where a.intID = '14'
Microsoft SQL Server 2008
Last Comment
dlavar
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Yes it's only one value that = 14. I removed the quotes and it's still pulling all of them.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
the RecordID belongs to tblAAPPayment. tblOnlineAAPAdjusters doesn't have a vchRecordID, but it has the confirmation num which is the same as the paymentnum in the Payment table.
What is the datatype of tblOnlineAAPAdjusters .vchConfirmNum and
tblOnlineAAPAdjusters .vchPaymentNum?
Try
Select a.vchRecordID
from tblAAPPayment p
inner join tblOnlineAAPAdjusters a on a.vchConfirmNum = p.vchPaymentNum
where a.intID = 14
tblOnlineAAPAdjusters .vchPaymentNum?
Try
Select a.vchRecordID
from tblAAPPayment p
inner join tblOnlineAAPAdjusters a on a.vchConfirmNum = p.vchPaymentNum
where a.intID = 14
Try
Select p.vchRecordID
from tblAAPPayment p
inner join tblOnlineAAPAdjusters a on a.vchConfirmNum = p.vchPaymentNum
where a.intID = 14
Select p.vchRecordID
from tblAAPPayment p
inner join tblOnlineAAPAdjusters a on a.vchConfirmNum = p.vchPaymentNum
where a.intID = 14
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I found out what my problem was. It was an issue in my database. Thanks for your help