3,015
Can someone help me write a SIMPLE query that joins these two tables on CUSTNMBR? I've asked for help with queries in the past (which I am so thankful for) but I can't make heads or tails of where the JOIN is occurring. I guess I just need the basics.
I need this data specifically:
RM10201
-DOCDATE
-ORTRXAMT
-CURTRXAM
RM00101
-CUSTNAME
Thanks!
*This post is locked for comments
Hi,
Much like Sanyays' script, but now using the RM20101 and RM10201:
SELECT dbo.RM20101.DOCDATE, dbo.RM20101.ORTRXAMT, dbo.RM20101.CURTRXAM, dbo.RM10201.CUSTNMBR
FROM dbo.RM10201 with (nolock) INNER JOIN
dbo.RM20101 with (nolock) ON dbo.RM10201.CUSTNMBR = dbo.RM20101.CUSTNMBR
Let me know if you have further questions.
SELECT dbo.RM20101.DOCDATE, dbo.RM20101.ORTRXAMT, dbo.RM20101.CURTRXAM, dbo.RM00101.CUSTNAME
FROM dbo.RM00101 with (nolock) INNER JOIN
dbo.RM20101 with (nolock) ON dbo.RM00101.CUSTNMBR = dbo.RM20101.CUSTNMBR
Cheers!
Sanjay
I'm sorry. I meant RM20101, not RM10201. Thank you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (