我有两张不同的桌子.一个是讲师,第二个是学生.两种表结构如下:
________INSTRUCTOR_________
instructorid schoolid instructorusername instructorfirstname instructorlastname instructortitle level
1 1 inst_A first_A Last_A RN 3
2 1 inst_B first_B Last_B TD 3
3 1 inst_C first_C Last_C FP 3
________STUDENT_________
studentid schoolid studentusername studentfirstname studentlastname level
1 1 stud_A first_A Last_A 4
2 1 stud_B first_B Last_B 4
3 1 stud_C first_C Last_C 4
现在,我想从两个表中选择数据,其中schoolid为’1′,结果将类似于Bellow:
________RESULT_________
id schoolid username firstname lastname title level
1 1 inst_A first_A Last_A RN 3
2 1 inst_B first_B Last_B TD 3
3 1 inst_C first_C Last_C FP 3
1 1 stud_A first_A Last_A 4
2 1 stud_B first_B Last_B 4
3 1 stud_C first_C Last_C 4
有没有办法这样做?请任何人帮助我.我之前从未这样做过.
先感谢您