Hallo,
Du hättest dir mal durchlesen sollen wie die Update-Syntax funktioniert...
Es müsste ungefähr so gehen: (Keine Garantie dass es fehlerfrei ist!)
SQL-Code:
UPDATE
warenbestand
SET
products_price =
(
SELECT
EK_EUR + iif(URA_PREIS is NULL,0,URA_PREIS)
FROM komsa
WHERE (komsa.komsanummer = warenbestand.external_id)
)
Michael
"Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination,
but because their imagination reveals worlds that others cannot see."