实验六连接查询实验报告.docx

实验六连接查询试验报告市场营销152 08刘运良1620153968前提：还原数据库sales，student-mis针对sales数据库查询所有员工的姓名，部门名称，及工资。selectemployee.Employee_Name,employee.Wages,department.Department_Namefromemployeeinnerjoindepartmentonemployee.Department_ID=department.Department_ID查询公司员工销售记录，并列出员工姓名及客户姓名。selectemployee.Employee_Name,customer.Customer_Namefromsell_orderinnerjoinemployeeonsell_order.Employee_ID=employee.Employee_IDinnerjoincustomeronsell_order.Custom_ID=customer.Customer_ID查询所有产品的产品编号，名称，类别名称。selectgoods.Goods_ID,goods.Goods_Name,goods_classification.Classification_Namefromgoodsinnerjoingoods_classificationongoods.Classification_ID=goods_classification.Classification_ID查询所有订单的产品名称，客户姓名，员工姓名及运输公司名称。selectgoods.Goods_Name,customer.Customer_Name,employee.Employee_Name,transporter.Transport_Namefromgoods,customer,employee,transporter,sell_orderwhereemployee.Employee_ID=sell_order.Employee_IDandcustomer.Customer_ID=sell_order.Custom_IDandgoods.Goods_ID=sell_order.Goods_IDandtransporter.Transporter_ID=sell_order.Transporter_ID针对student-mis数据库查询出成绩表中不及格学生的学号，姓名，成绩。selectstudent_info.Student_ID,student_info.Student_Name,student_course_info.Scorefromstudent_info,student_course_infowherestudent_course_info.Score60 andstudent_course_info.Student_ID=student_info.Student_ID显示所有学生的姓名，选修课程名。selectstudent_info.Student_Name,course_info.Course_Namefromstudent_info,course_info,student_course_infowherestudent_info.Student_ID=student_course_info.Student_IDandcourse_info.Course_No=student_course_info.Course_No显示所有选修了计算机文化基础的学生姓名及成绩。selectstudent_course_info.*,student_info.Student_Name,student_course_info.Scorefromstudent_info,student_course_info,course_infowherestudent_info.Student_ID=student_course_info.Student_IDandstudent_course_info.Course_No=course_info.Course_Noandcourse_info.Course_Name=计算机文化基础找出数据结构课程成绩在90分以上的学生姓名及成绩。selectstudent_course_info.*,student_info.Student_Name,student_course_info.Scorefromstudent_info,student_course_info,course_infowherestudent_course_info.Score90 andcourse_info.Course_Name=数据结构and