Multiple JOIN problem - INNER & LEFT

[Beldrueger]

Here is a sample of the join that I am trying to get to work in Access '97:

Select sale_class_code as Main
FROM freshness 
       
      INNER JOIN FL_DATE ON (FL_DATE.USA_DT = freshness.ord_dspch_dt) 
      INNER JOIN CLK_DEST_TYPE ON (LOC_TYPE_CODE = acctg_dest_type)
      LEFT JOIN [SS-GB] ON (freshness.sale_class_code = [SS-GB].BDC_CLASS)

I left out the bulk of the SQL. I am just testing this JOIN ... but I can't seem to get it to work ... please tell me anything that works ... i switched from WHERE's to INNER JOIN's only b/c the WHERE's were not working