SELECT image_to_stack.image_id, image_to_stack.image_url, image_to_stack.stack_pos, image_to_stack.x_dim, image_to_stack.y_dim, image_to_stack.z_coor, image_to_stack.stack_id, image_to_stack.time_id, image_to_stack.microscopy_filter_id, tblsubstance.substance_id, tblsubstance.name, image_to_stack.stack_description FROM tblsubstance, image_to_stack WHERE image_to_stack.target_id = tblsubstance.substance_id