现在我想从两个表中为特定的RegNo选择值.
这就是我正在做的事情
SELECT Test1.SurName,Test2.Class,Test2.Medium FROM Test1,Test2 JOINS Test2 ON Test1.RegNo = Test2.RegNo
但我的查询是错误的.
SELECT Test1.SurName,Test2.Medium FROM Test1 INNER JOIN Test2 ON Test1.RegNo = Test2.RegNo
