Joining tables with Col=Col AND additional condition

[karlomutschler]

Hello and good day,

I need to join the following two tables in Access:

The SQL script looks like this:
FROM VBWADM.VBW_FACT a,
ADBADM.SALES_ORG b
WHERE (a.SALES_NUMBER=b.SALES_NUMBER_ AND a.REPORT_DATE BETWEEN b.VALID_FROM AND b.VALID_THRU)

The SQL-Statement generated by Access (using the Query-Editor) is as follows:
FROM A INNER JOIN B ON A.SALES_NUMBER = B.SALES_NUMBER AND (here the rest of the condition should follow)

How do I …. ?

Any assistance highly appreciated

Thanks and kindest regards.
Karlo

 

[PHV]

Sorry, but I don't see the problem

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886