Select Distinct yqid from sl_gdxx Where jbsj>'20110331235409' Select yqid,gdbh from sl_gdxx Where jbsj>'20110331235409' Select Distinct gd.yqid From (Select yqid,gdbh from sl_gdxx Where jbsj>'20110331235409') gd, bl_fkxx fk Where gd.gdbh=fk