SELECT image_to_time.image_id, image_to_time.image_url, image_to_time.stack_pos, image_to_time.x_dim, image_to_time.y_dim, image_to_time.z_coor, image_to_time.stack_id, image_to_time.time_id, image_to_time.microscopy_filter_id, image_to_time.substance_id, image_to_time.name, image_to_time.field_of_view_id, tblfield_of_view.slide_id, image_to_time.stack_description, tblfield_of_view.x_coor, tblfield_of_view.y_coor FROM image_to_time, tblfield_of_view WHERE image_to_time.field_of_view_id = tblfield_of_view.field_of_view_id