SELECT
       h.import_date,
       h.filename,
       h.username,
       f.import_view,
       ex.exception_details
FROM   imtbl_import_exceptions ex LEFT JOIN
       imtbl_import_fields     f ON f.pkey = ex.import_fields LEFT JOIN
       imtbl_import_history    h ON h.pkey = f.import_history