UPDATE e
SET Mari = 'M'
FROM Employee e
JOIN Contact ce
ON e.ContactID = ce.ContactID
WHERE ce.FirstName = 'jo'
AND ce.LastName = 'brown';问一下关于JOIN后边那句话是什么意思?为什么要加JOIN?直接用下边的代码不行么?
UPDATE e
SET Mari = 'M'
FROM Employee e
WHERE ce.FirstName = 'jo'
AND ce.LastName = 'brown';
SET Mari = 'M'
FROM Employee e
JOIN Contact ce
ON e.ContactID = ce.ContactID
WHERE ce.FirstName = 'jo'
AND ce.LastName = 'brown';问一下关于JOIN后边那句话是什么意思?为什么要加JOIN?直接用下边的代码不行么?
UPDATE e
SET Mari = 'M'
FROM Employee e
WHERE ce.FirstName = 'jo'
AND ce.LastName = 'brown';
UPDATE e
SET Mari = 'M'
FROM Employee e , Contact ce
where e.ContactID = ce.ContactID
AND ce.FirstName = 'jo'
AND ce.LastName = 'brown'