1- select s.*, c.COUNTRY_CURRENCY from TBL_SHOW s inner join TBL_COUNTRY c on s.SHOW_PAYCOUNTRY = c.COUNTRY_ID where s.SHOW_ID=