SELECT * ;
   FROM nonConf nc ;
      LEFT JOIN car_misc cm ON nc.car_id = cm.car_id ;
      LEFT JOIN car_extension ce ON nc.car_id = ce.car_id
   INTO CURSOR car_temp

Worked as advertised. Thanks for the explanantion. I was just cutting and pasting the code from the query designer without really examining it too closely.

Kevin