Inner Join SQL

[dccjr3927]

Trying my first inner join on a multitable query (below).

strRptSQL1 = "SELECT WOTracking.*, Inventory.BoxingType, Inventory.ProcessCode, FROM WOTracking INNER JOIN Inventory ON WOTracking.SKU = Inventory.SKU WHERE ContractCo = '" & Me.cbxContractCo & "' AND  Date_Time >= #" & Format(dt1, "yyyy-mm-dd") & "# AND Date_Time < #" & Format(dt2, "yyyy-mm-dd") & "# ORDER BY OrderNo;"

I am getting an Error 3141 'SELECT includes a reserved wordor an argument name...'. I got this syntax from another forum, but am not sure exactly what I am looking for.

Any help would be greatly appreciated.

[pbaldy]

For starters, the comma before FROM needs to be deleted.

[dccjr3927]

Yep. So, I get the donkey award for the day. Thanks you for the good eyes.

[pbaldy]

No problemo.