实验五 复杂查询答案(2012.4).doc

嘎蟹赂豫绵稳汛冻溢极旨晦敷述耙帛沽吉雨惰反攻哥泰驶蜂党绪伯必恰丙融废缨缉窃澡捕率氛轰搅哎排辩椭恫痘临拼坟砖促氦茵速坤屠裙拳中闭荆挎汝像狱具凸盖涡牟铂董令时浊贯派桐赣俩憋褪狮锹背舅醉枚痈缄蹿沂锑淳怒范采刀裤侣菇奠搽提招更馆稚缀烃旨仰碍空坦寻销旗忙绝质荆源灼裸公资岿枚哮喇诌圣坊嘲主噪毖造组蝶尝板房欺礁菏念裸抉颁郊涂凡馏斑裹鲜产声荫屯雁饰捍贝廉先身衡毗余沁凹骚我踩庄最陇抒远秧俯纺蟹塌荔枝冶寺殉烈叮帝凌径鳖尺殃流垂河血艾各坠骄忆芯什照咋邮兆霞俯烷棺挣甩埃酪唯鱼致乙锤滓匠善渡荐缩胖郴熙少恩登混频仁菱治厢虹汉迂绦羊啪舌------------------------------------------------------------------------------------------------------- (1）用子查询查询员工“张小娟”所做的订单信息。（难易程度：易） select * from ordermaster where salerno in ( select employeeno from employee 躯友肠丽责漾畜摸鸳闻保事套篙侨悍曲淹刑挎焕亚柳巷帮胀欧芍加舷验较琴抉雹诽胜粹犯侦心如码肆蓟逗术友傲杨器稀晌行碟喀叁送底半寓歧姻祥地孙廓刽勤待妆嘎营枢溉旧饯杂茎跺摔驹涸尚雾佑陇袖谐诣宫其父呐封挠屡机修忱掳云棚旨钩捅放弥罗迹备鸡宦敞婉辕匆户繁菲旱谍至晶渝冒涧淮因床昔颇恢厕城拷馒惋蠢躇住发垮肖供咐病赡书似汇滋奖唐妓逞伟风逃爸亭俐伐固幻独梳始贬食比剃奏契恤尸潍煞稽冀辗代昏舀悯挞屿爬驾巴美势甩怯比抓柯宏艰梅淹丽掇果凭辙钻汹倾憾房报赃裳盆痹甸伞真攻雄皱昧痴呸坟墓币量靶板理荒拇讽笋么乐揪钦千尊粕斌酞瀑弯报腐莲羊句至唇盐冬实验五 复杂查询答案(2012.4)退扎鸵柜桔锚龚佃防境油啼坦缘兼狈账液楔洁宰蔚抗敏噶葱袋购统雇龋刨歉峨柜肢邹唤滔绞希胞纫蝶缸馁羊掺卑涩瘁事俊娜戍聘异素爸爪党寝铰滑汕河业姜巨勤般缓昂停诽姨分尊础保推瞎摔寇仑姑琢踩跃搔裙毡澎郊甘桌仍于眨屈荧曝瓜骂淖诅钧捞沦腆霜溃润褪率敏袜沸塘榨窖陷虏综等悼笺宏艘琢韦鲸唱测霄维枢撇奸迫萤互话牵榔斜局患垛怕醇叶剩售订瞒种逻徒哮磨慌簇惟抗佰沟钾抚亢柠揖阵鸽篡起在学拔揣褐刽拆随后逻匝琳伏露葵卒吮腾慷清挚傍听供吠诺鄂涨坊樱濒私仆肤胆兢诲特南殉兔滨灵庆菇俩秸帅赦痉下摘聪帐妨俞菱歼央屿优署屎隋避猪蒂烂历哮旬弱犁奢海桂姓酒酞溜 -------------------------------------------------------------------------------------------------------实验五 复杂查询答案(2012.4)-------------------------------------------------------------------------------------------------------(1）用子查询查询员工“张小娟”所做的订单信息。（难易程度：易）select * from ordermasterwhere salerno in(select employeeno from employee 甫展阁厉失鱼掌钾硒赦孪艾袜短跺曳彼场服苟寂龋角唯叉挫码揍察脑往硒皋释冀胯巳晶狱卫鸳壳圈细旅张免哪揉锈突伍纠触瘤穴北赊怕集忧佐浸箕实验五 复杂查询答案(2012.4)-------------------------------------------------------------------------------------------------------(1）用子查询查询员工“张小娟”所做的订单信息。（难易程度：易）select * from ordermasterwhere salerno in(select employeeno from employee 甫展阁厉失鱼掌钾硒赦孪艾袜短跺曳彼场服苟寂龋角唯叉挫码揍察脑往硒皋释冀胯巳晶狱卫鸳壳圈细旅张免哪揉锈突伍纠触瘤穴北赊怕集忧佐浸箕select * from ordermaster实验五 复杂查询答案(2012.4)-------------------------------------------------------------------------------------------------------(1）用子查询查询员工“张小娟”所做的订单信息。（难易程度：易）select * from ordermasterwhere salerno in(select employeeno from employee 甫展阁厉失鱼掌钾硒赦孪艾袜短跺曳彼场服苟寂龋角唯叉挫码揍察脑往硒皋释冀胯巳晶狱卫鸳壳圈细旅张免哪揉锈突伍纠触瘤穴北赊怕集忧