select in 사용예제

select image1, image2, image3  from cinema_info where idx in(select idx from core_trade where user_id='test' and status='y');