select gd_name, (select pl_web_price from t_price_level where gd_seq='gd4493' ) price, gd_sale_startdt, gd_sale_enddt from t_goods where gd_seq='gd4493'