<#if SQLdialect='Postgres'<#if SQLdialect='Postgres'>
UPDATE tmp_buch
SET z_name = gxstage_zp.druck,
z_name2 = gxstage_zp.lang_1
FROM gxstage_zp
WHERE z_nr is not null and gxstage_zp.apnr = tmp_buch.z_nr;
<#else>

UPDATE tmp_buch
SET (z_name, z_name2) =
((SELECT druck, lang_1
FROM gxstage_zp
WHERE gxstage_zp.apnr=tmp_buch.z_nr))
WHERE z_nr is not null;