<div>
Check this out I think it'd be helpful:<br />
<br />
<a href="https://stackoverflow.com/questions/24800340/update-a-table-with-join" rel="ugc">https://stackoverflow.com/questions/24800340/update-a-table-with-join</a>
</div>


<div>
<div class="content wysiwyg-content">
Hello, i hope my question is not to stupid, but i have sometimes to deal with our firebird database and just need quick help:<br />
<br />
How to update values with a join condition:<br />
<br />
&quot;<br />
select Vauftragnr, Kundname, Lager from wws_verkauf1<br />
join wws_verkauf2 on wws_verkauf1.VAUFTRAGNR = wws_verkauf2.VAUFTRAGNR<br />
where artikelnr=&quot;30000&quot; and datum&gt;&quot;01.01.2018&quot; and erledigt=&quot;N&quot;<br />
&quot;<br />
<br />
i would like to update the &quot;Lager&quot;
</div>
</div>


Hello, i hope my question is not to stupid, but i have sometimes to deal with our firebird database and just need quick help:

How to update values with a join condition:

"
select Vauftragnr, Kundname, Lager from wws_verkauf1
join wws_verkauf2 on wws_verkauf1.VAUFTRAGNR = wws_verkauf2.VAUFTRAGNR
where artikelnr="30000" and datum>"01.01.2018" and erledigt="N"
"

i would like to update the "Lager"

Easy Firebird question

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.