Skip to Content
0
Former Member
Oct 28, 2010 at 06:09 PM

Query that link two tables together

7 Views

I am using this query to extract Account Payable data:

SELECT T0.DocNum, T0.DocStatus, T0.DocDate, T0.DocDueDate, T0.CardCode, T0.CardName, T0.NumAtCard, T0.DocTotal FROM Akron.dbo.OPCH T0

How would I also add the unique number for each individual payment from these tables?

OVPM and VPM2.

What field links these 2 tables together?