在MS Access中联接两个表 [英] Join two tables in MS Access

问题描述

我创建了两个表，table1用于学生的个人详细信息，table2用于学生的商标详细信息.现在，我希望所有学生详细信息都放在一个表中.

I have created two tables, table1 for student personal details, table2 for student mark details. Now I want all student details in a single table.

推荐答案

U必须将两个这样的表连接起来

SELECT S.Studentname，M.subjectname来自tblstudent的M.marks S内联接tblmarks M ON S.Studentid = M.Studentid

U have to join two tables like this

SELECT S.Studentname, M.subjectname M.marks FROM tblstudent S INNER JOIN tblmarks M ON S.Studentid= M.Studentid

您正在寻找合并这两个表的方法.由于它是Access，因此我将使用查询:

http://office.microsoft.com/en-us/access-help/join-tables-and-queries-HA010096320.aspx [

You''re looking to join the two tables. As it''s Access I''d use a Query:

http://office.microsoft.com/en-us/access-help/join-tables-and-queries-HA010096320.aspx[^]

这篇关于在MS Access中联接两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！