我读过许多其他的答案,但无法做到这一点!invGroups on invtypes.groupID = invgroups.groupID如果类别ID与25匹配,我只想从invTypes中删除记录会非常感谢你的帮助delete from invTypes
inner join invGroups on invtypes.groupID = invgroups.groupIDINNER JOIN invTypes ON (invGroups.groupID
所以我有一个相关子查询,我读到这不是最有效的方法。因此,我希望将此查询转换为内连接查询。SELECT fieldA WHERE tableB.fieldA= tableA.fieldA)这导致了Error while executing SQL query on database 'DB': near "a": syntax error
我在这里的<
下面的SQL语句在我的数据库上执行正常:INNER JOIN tblKeyPointLinks AS l ON k.KPIID = l.KPIIDp.KptID = l.KptID WHERE h.CaseNo = 50043;INNER JOIN tblHistory AS h ON h.HistoryID = p.HistoryID
WHE