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