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