sql - Nested Inner Join With Outer Join in MS ACCESS -

i've reviewed of previous questions regarding topic , can't seem answer issue.

i have 3 tables (lot, menu, sku).

i need ingredients in menu , associated product names in sku given sku, if there no associated row in lot

my current query:

    select m.ingrsku, m.ingmeasurementid, s.productname, m.quantity   mquantity, l.quantity, l.lot      (menu m      inner join sku s on m.ingrsku = s.sku)     left outer join lot l on m.ingrsku + '-070516j' = l.lot , l.destinationid = 2      m.skutype = 4 , m.sku = '1321' 

i read outer join has come after inner, i'm still getting "join expression not supported" error.

any ideas?

update: query provides desired resultset in sql server; can't run in access

did try without brackets?

select m.ingrsku, m.ingmeasurementid, s.productname, m.quantity , mquantity, l.quantity, l.lot  menu m  join sku s on m.ingrsku = s.sku left join lot l on m.ingrsku + '-070516j' = l.lot , l.destinationid = 2  m.skutype = 4 , m.sku = '1321'