begin</br>select a.c_vipkh,a.c_xingm,a.c_soujhm,a.c_xingm,c.c_mingc,a.c_sex,to_char(a.d_birthday,'YYYY-MM-DD'),a.c_shopid,to_char(a.d_id,'YYYY-MM-DD')
	,a.c_shengf,a.c_diqu,a.c_beiyzd1
	from g_vip a,temp_vip b,r_vipcard c where a.c_vipbh=b.c_vipbh and a.n_leix=c.n_leix</br>end</br>