主页 / 问题 / 942873
Accepted
corocoto
Asked:2020-02-09 21:07:01 +0000 UTC2020-02-09 21:07:01 +0000 UTC

SQL 查询无法正常工作

  • 772

此查询应加载有关其 id 不在另一个表中的路由的数据。相反，这些记录只是重复的。

SELECT tRoutes.ID_Route, tRoutes.sNameOfRoute from tRoutes
INNER JOIN tGroupsRoutes ON tRoutes.ID_Route <> tGroupsRoutes.ID_Route
c#

1 个回答

  1. Best Answer
    SELECT tRoutes.ID_Route, tRoutes.sNameOfRoute from tRoutes LEFT JOIN tGroupsRoutes ON tRoutes.ID_Route=tGroupsRoutes.ID_Route WHERE tGroupsRoutes.ID_Route IS NULL
    • 1

相关问题