<legend id='EaMnZ'><style id='EaMnZ'><dir id='EaMnZ'><q id='EaMnZ'></q></dir></style></legend>

        <i id='EaMnZ'><tr id='EaMnZ'><dt id='EaMnZ'><q id='EaMnZ'><span id='EaMnZ'><b id='EaMnZ'><form id='EaMnZ'><ins id='EaMnZ'></ins><ul id='EaMnZ'></ul><sub id='EaMnZ'></sub></form><legend id='EaMnZ'></legend><bdo id='EaMnZ'><pre id='EaMnZ'><center id='EaMnZ'></center></pre></bdo></b><th id='EaMnZ'></th></span></q></dt></tr></i><div id='EaMnZ'><tfoot id='EaMnZ'></tfoot><dl id='EaMnZ'><fieldset id='EaMnZ'></fieldset></dl></div>
      1. <small id='EaMnZ'></small><noframes id='EaMnZ'>

          <bdo id='EaMnZ'></bdo><ul id='EaMnZ'></ul>
      2. <tfoot id='EaMnZ'></tfoot>
      3. 如何在 SQL Server 中使用 INNER JOIN 进行删除?

        How can I delete using INNER JOIN with SQL Server?(如何在 SQL Server 中使用 INNER JOIN 进行删除?)
          • <bdo id='LSt94'></bdo><ul id='LSt94'></ul>

              <tbody id='LSt94'></tbody>
            <i id='LSt94'><tr id='LSt94'><dt id='LSt94'><q id='LSt94'><span id='LSt94'><b id='LSt94'><form id='LSt94'><ins id='LSt94'></ins><ul id='LSt94'></ul><sub id='LSt94'></sub></form><legend id='LSt94'></legend><bdo id='LSt94'><pre id='LSt94'><center id='LSt94'></center></pre></bdo></b><th id='LSt94'></th></span></q></dt></tr></i><div id='LSt94'><tfoot id='LSt94'></tfoot><dl id='LSt94'><fieldset id='LSt94'></fieldset></dl></div>

                <legend id='LSt94'><style id='LSt94'><dir id='LSt94'><q id='LSt94'></q></dir></style></legend>

                  <small id='LSt94'></small><noframes id='LSt94'>

                • <tfoot id='LSt94'></tfoot>

                • 本文介绍了如何在 SQL Server 中使用 INNER JOIN 进行删除?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我想在 SQL Server 2008 中使用 INNER JOIN删除.

                  I want to delete using INNER JOIN in SQL Server 2008.

                  但我收到此错误:

                  消息 156,级别 15,状态 1,第 15 行
                  关键字INNER"附近的不正确语法.

                  Msg 156, Level 15, State 1, Line 15
                  Incorrect syntax near the keyword 'INNER'.

                  我的代码:

                  DELETE 
                  FROM WorkRecord2 
                  INNER JOIN Employee 
                          ON EmployeeRun=EmployeeNo
                  WHERE Company = '1' 
                      AND Date = '2013-05-06'
                  

                  推荐答案

                  您需要指定要从哪个表中删除.这是一个带有别名的版本:

                  You need to specify what table you are deleting from. Here is a version with an alias:

                  DELETE w
                  FROM WorkRecord2 w
                  INNER JOIN Employee e
                    ON EmployeeRun=EmployeeNo
                  WHERE Company = '1' AND Date = '2013-05-06'
                  

                  这篇关于如何在 SQL Server 中使用 INNER JOIN 进行删除?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  Select n random rows from SQL Server table(从 SQL Server 表中随机选择 n 行)
                  SQL query to select dates between two dates(用于选择两个日期之间的日期的 SQL 查询)
                  Table Naming Dilemma: Singular vs. Plural Names(表命名困境:单数与复数名称)
                  INSERT statement conflicted with the FOREIGN KEY constraint - SQL Server(INSERT 语句与 FOREIGN KEY 约束冲突 - SQL Server)
                  How ROWNUM works in pagination query?(ROWNUM 如何在分页查询中工作?)
                  Oracle SQL query: Retrieve latest values per group based on time(Oracle SQL 查询:根据时间检索每组的最新值)

                  • <small id='IS1Tf'></small><noframes id='IS1Tf'>

                      <legend id='IS1Tf'><style id='IS1Tf'><dir id='IS1Tf'><q id='IS1Tf'></q></dir></style></legend>
                      <tfoot id='IS1Tf'></tfoot>
                      <i id='IS1Tf'><tr id='IS1Tf'><dt id='IS1Tf'><q id='IS1Tf'><span id='IS1Tf'><b id='IS1Tf'><form id='IS1Tf'><ins id='IS1Tf'></ins><ul id='IS1Tf'></ul><sub id='IS1Tf'></sub></form><legend id='IS1Tf'></legend><bdo id='IS1Tf'><pre id='IS1Tf'><center id='IS1Tf'></center></pre></bdo></b><th id='IS1Tf'></th></span></q></dt></tr></i><div id='IS1Tf'><tfoot id='IS1Tf'></tfoot><dl id='IS1Tf'><fieldset id='IS1Tf'></fieldset></dl></div>
                        <bdo id='IS1Tf'></bdo><ul id='IS1Tf'></ul>

                            <tbody id='IS1Tf'></tbody>