Yeah, I wanted to do this the other day (but found a different way to
structure the query so never got round to posting the question here).
The Firebird book contains what I found to be incomplete and
contradictory information on this point.
On 26/02/2014 10:43, checkmail wrote:
Hello,
I get an error message during executing the following statement:
with mat as (
select a.teilenr, c.vkpreis, a.matteilenr, c.bezeichnung from
tmaterial a left join tteile c on a.teilenr = c.teilenr
where a.kundennr = 24823 )
update tteile set tteile.minvk = mat.vkpreis * 0.90 where teilenr =
mat.teilenr
I know, I can do the following (update XX where (select...)
Why complain firebird the update..?
Thank you,
Best regards
Olaf
--
Tim Ward
