projects
/
kivitendo-erp.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
5301735a3a7959ad6789c72daf8fee586583c3ca
[kivitendo-erp.git]
/
chart_taxkey_id_from_taxkeys.sql
1
-- @tag: chart_taxkey_id_from_taxkeys
2
-- @description: chart.taxkey_id aus taxkeys aktualisieren
3
-- @depends: release_2_6_2
4
-- @charset: utf-8
5
UPDATE chart
6
SET taxkey_id = (
7
SELECT taxkey_id
8
FROM taxkeys
9
WHERE taxkeys.chart_id = chart.id
10
ORDER BY startdate DESC
11
LIMIT 1
12
);