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:
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
Sanjay Kumar Rajarao. ACA, MCPhttp://www.sanjaykumar.us | firstname.lastname@example.org
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.
Tristan Thor A. Clores
I'm sorry. I meant RM20101, not RM10201. Thank you.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics