http://u.115.com/file/aqpa2che这是个数据库文件，要求如下：

Reports should display two or more child rows for each parent row. For example, a report showing courses that instructors are approved to teach would display each instructor with two or more courses that the instructor is approved to teach. If you need to add data, you may do so.

开始的时候英文翻译有无，现在重新整理一下
1. Create a report using the wizard or based on an SQL query that shows courses instructors are approved to teach.
这个应该是只显示可以有老师许可上课程，仅仅是课程的名字
2. Create a report using the wizard or based on an SQL query that shows student information and what the students' majors are.
显示学生信息和专业
3. Create a report using the wizard or based on an SQL query that shows student information by zip code. Zip codes should be in increasing order.
按邮编的升序显示学生信息
4. Create a report using the wizard or based on an SQL query that shows the Course Names and the students in each course. Sort Course Numbers in increasing order.
显示课程和学生，按课程排序
5. Create a report using the wizard or based on an SQL query that shows the status for each student. The students should be in alphabetical order by last name followed by first name.
显示学生状态，按学生名字的阿拉伯字母顺序排序
The text and and the tutorials provide the knowledge needed to create a sample data entry form. Each system has unique characteristics with respect to data input. The form should be created in Access and should be representative of one of the major entities in the database. Appropriate design elements, such as the source documents, the need for forms and subforms, and the GUI control options, should be considered.

Create a form based on an SQL query.
Create a form using the wizard.
Create a form that you design using a master detail relationship.

如果谁帮做了缺积分的想要积分，我可以送给5000~

做好请联系我QQ：1191570 或者Email:tiancaigk@gmail.com
太谢谢咯！

[本帖最后由 天才GK 于 2011-6-20 00:39 编辑]

帮顶。不过楼主是学这个专业的吗？怎么每次都求。

MBA的，不过不小心选了这个数据库管理课，实在玩不来

人工置顶啊，我很着急啊，各位大神，不要光看肉蒲团了啊！！

小叮当你在哪里！

我感觉我要死了~

oracle 还可以

ACCESS 不是很懂....

select a.*,c.* from coures a ,approproved_instuctor b,instructor c
where a.course_no=b.course_no
and b.instructor_Id=c.instructor_id

这是第一道作业

shows courses instructors are approved to teach.

星月之隼 17:47:13
答案一：
SELECT course_name, last_name, first_name
FROM course AS a, approved_instructor AS b, instructor AS c
WHERE (((a.Course_No)=.[course_no]) AND ((b.Instructor_ID)=[c].[instructor_id]));


答案二：SELECT student.First_Name, student.Last_Name, student.Major
FROM student;

答案三：
SELECT first_name, last_name, zip
FROM student
ORDER BY student.Zip;

星月之隼 17:47:28
答案四：SELECT first_name, last_name, major
FROM student AS a, student_grade AS b, class AS c, course AS e
WHERE a.student_id=b.student_id
and b.class_id=c.class_id
and c.course_no=e.course_no;

天才GK-Proto 17:47:11
哦 我看到了
天才GK-Proto 17:47:16
你那个是中文的
天才GK-Proto 17:47:21
谢谢·
星月之隼 17:47:50
答案5：SELECT First_Name, Last_Name, status
FROM student
ORDER BY Last_Name;

路过问一下
from a,b
where a.c1=b.c1
和
from a inner join b on a.c1=b.c1
哪种写法更主流？

如果没记错楼主以前是混2手区的吧,好久不见

from a,b
where a.c1=b.c1

比较主流

第二种 的写法比较麻烦 我没有用过

第二种写法比较浪费系统资源

两种写法不都一样吗，inner join和直接等号好像效果差不多的，
当然是怎么省事怎么来呗

不好意思，我下午在外面逛，看不到你的数据库结构。

哪种主流我不太清楚。

但是从效率来说，我以前，大约02年的时候，在sql2000上的时候做过一些实验，在数据量一百万以下，inner join和where没什么区别，但500万以上的多表join数据量， inner join的效率要比where高。

当时vb靠平时成绩混了个及格的路过

说到执行效率，
能用inner join,where就一定不要用left join.
避免用in, 少用or ,避免null值
inner join和exists要灵活应用，不同表结构各有优势。不要养成习惯用法。
where里尽量少用变量和对表达式的计算。
用varchar代替char
index不宜太多。

......

@便秘的耶酥 mark

我大致的观点与小叮当相同，希望可以对lz有帮助。

所谓效率，跟你优化器选择和索引设置都有关系，只有根据情况来定。