不是视图,用的是mssql数据库,直接用select语句连接的两个表,语句如下: SELECT XS_ClassINfo.ClassID AS 班级编码, XS_ClassINfo.ClassName AS 班级名称, XS_ClassINfo.DePartyID AS 所在系,XS_ClassINfo.MajorID AS 专业编码, XS_CDMajor.MajorName AS 专业, XS_ClassINfo.MajorDirect AS 专业方向, XS_ClassINfo.CDemo AS 备注 FROM XS_ClassINfo INNER JOIN XS_CDMajor ON XS_ClassINfo.MajorID = XS_CDMajor.MajorID WHERE (XS_ClassINfo.DePartyID = ?)当执行删除或插入操作时是对两个表同时进行操作,而我只希望对XS_ClassINfo进行操作!
SELECT XS_ClassINfo.ClassID AS 班级编码, XS_ClassINfo.ClassName AS 班级名称, XS_ClassINfo.DePartyID AS 所在系,XS_ClassINfo.MajorID AS 专业编码, XS_CDMajor.MajorName AS 专业, XS_ClassINfo.MajorDirect AS 专业方向, XS_ClassINfo.CDemo AS 备注
FROM XS_ClassINfo INNER JOIN
XS_CDMajor ON XS_ClassINfo.MajorID = XS_CDMajor.MajorID
WHERE (XS_ClassINfo.DePartyID = ?)当执行删除或插入操作时是对两个表同时进行操作,而我只希望对XS_ClassINfo进行操作!