Writing SQL for DB2 in MS Access 97

[grunasal]

I need some help on how to write an inner join SQL query between two tables in Access 97. Not sure where to go from here.

 

[advpay]

What type of query: select, make table...with an inner join? What are the table names and the fields you would like?

 

[advpay]

Here's a Select example:


SELECT [Sales Order].[Sales Order Number], [Sales Order].[Sales Date], IIf(Not IsNull([Company]),[Company],[Last name] & ", " & [First Name]) AS [Company Display], [Sales Order].Tax, [Sales Order].[Tax 2], [Sales Order].Freight, [Sales Order].Other, [Sales Order].[Create Invoice], [Sales Order].[Invoice Number]
FROM [Sales Order] INNER JOIN Customers ON [Sales Order].[Sold to Customer] = Customers.[Customer Number]
WHERE (([Sales Order].[Sales Date] Between [Forms]![Invoice Batch Create]![Start Date] And [Forms]![Invoice Batch Create]![End Date]) AND ((IsNull([Sales Order].[Invoice Number]))<>False))
ORDER BY [Sales Order].[Sales Order Number];

 

[grunasal]

It's a select query with an inner join.

Below is the SQL, please tell me what I'm missing:

SELECT ARLIB.TWMCLAMP.MCCLM#, ARLIB.TWMCLAMP.MCINV, ARLIB.TWMCLAMP.MCVEND, ARLIB.TWMCLAMP.MCDTPO, ARLIB.TWMCLAMP.MCCCST, ARLIB.TWMCLAMP.MCWD, ARLIB.TWMCLAMP.MCIVDT, ARLIB.TWMCLAMP.MCIQTY, ARLIB.TWMCLAMP.MCICST, ARLIB.TWMCLAMP.MCIDIS, ARLIB.TWMCLAMP.MCMQTY, ARLIB.TWMCLAMP.MCMCST, ARLIB.TWMCLAMP.MCMDIS, ARLIB.TWMCLAMP.MCCHDT, ARLIB.TWMCLAMP.MCCPNY, ARLIB.TWMCLAMP.MCBINC, ARLIB.TWMATCDP.MDISBN, ARLIB.TWMATCDP.MDBINC

FROM ARLIB.TWMCLAMP INNER JOIN ARLIB.TWMATCDP
ON ARLIB.TWMCLAMP.MCVEND = ARLIB.TWMATCDP.MDVEND AND ARLIB.TWMCLAMP.MCINV = ARLIB.TWMATCDP.MDINV
AND ARLIB.TWMCLAMP.MCDTPO = ARLIB.TWMATCDP.MDDTPO AND ARLIB.TWMCLAMP.MCBINC = ARLIB.TWMATCDP.MDBINC

WHERE ARLIB.TWMCLAMP.MCVEND =