Kako izbrisati z INNER JOIN v strežniku SQL Server?

V strežniku SQL Server 2008 želim izbrisati z uporabo INNER JOIN.

Vendar dobim to napako:

Sporočilo 156, raven 15, stanje 1, vrstica 15 Nepravilna sintaksa v bližini ključne besede 'INNER'.

Moja koda:

DELETE FROM WorkRecord2 
INNER JOIN Employee ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'
Daniel Serodio
Edited question Npopoldan 49p15.5.20181tni 49trpopoldanni maj 2018 в 5:01
Programiranje
sql sql-server sql-server-2008 inner-join sql-delete
Ndopoldan 21p10.5.20134tni 21trdopoldanni maj 2013 в 11:38
6 ogledi
Rešitev

Določiti morate, iz katere tabele izbrišete podatke, tukaj je različica z vzdevkom:

DELETE w
FROM WorkRecord2 w
INNER JOIN Employee e
  ON EmployeeRun=EmployeeNo
WHERE Company = '1' AND Date = '2013-05-06'
taylorsabell
Edited answer Npopoldan 34p24.8.20162tni 34trpopoldanni avgust 2016 в 5:12
Komentarji (10)

Med DELETE in FROM dodajte ime tabele, iz katere želite izbrisati zapise, saj moramo določiti tabelo, ki jo želimo izbrisati. Prav tako odstranite klavzulo ORDER BY, ker pri brisanju zapisov ni treba ničesar urejati.

Vaša končna poizvedba naj bo torej takšna:

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

To vam je lahko v pomoč -

DELETE FROM dbo.WorkRecord2 
WHERE EmployeeRun IN (
    SELECT e.EmployeeNo
    FROM dbo.Employee e
    WHERE ...
)

Ali pa poskusite to -

DELETE FROM dbo.WorkRecord2 
WHERE EXISTS(
    SELECT 1
    FROM dbo.Employee e
    WHERE EmployeeRun = e.EmployeeNo
        AND ....
)
Devart
Edited answer Npopoldan 1p10.5.20134tni 1trpopoldanni maj 2013 в 12:19
Komentarji (1)