| Subject | UPDATE AND DELETE WITH JOIN |
|---|---|
| Author | Roberto Freitas |
| Post date | 2006-07-11T13:21:10Z |
Hello,
This is a valid sentence with SQL Server:
UPDATE MAT SET MAT.MT=137
FROM MAT INNER JOIN ALU ON MAT.ALREG = ALU.ALREG
WHERE ALU.EDCOD='TWQ';
With FireBird 1.5 I get Token unknow line 2 char 1 FROM
How can I do this kind of UPDATE with FireBird 1.5?
How can I do a similar DELETE (with JOIN) with FireBird 1.5?
This is a valid sentence with SQL Server:
UPDATE MAT SET MAT.MT=137
FROM MAT INNER JOIN ALU ON MAT.ALREG = ALU.ALREG
WHERE ALU.EDCOD='TWQ';
With FireBird 1.5 I get Token unknow line 2 char 1 FROM
How can I do this kind of UPDATE with FireBird 1.5?
How can I do a similar DELETE (with JOIN) with FireBird 1.5?