- ( SELECT comma(taxkey_id)
- FROM taxkeys tk
- WHERE tk.chart_id = c.id
- AND c.taxkey_id = tk.taxkey_id
- ORDER BY c.id
- ) AS taxkey_id,
+-- ( SELECT comma(taxkey_id)
+-- FROM taxkeys tk
+-- WHERE tk.chart_id = c.id
+-- AND c.taxkey_id = tk.taxkey_id
+-- ORDER BY c.id
+-- ) AS taxkey_id,
+
+ ( SELECT comma(taxkey)
+ FROM tax tx
+ WHERE tx.id in (
+ SELECT tk.tax_id from taxkeys tk
+ WHERE tk.chart_id = c.id
+ )
+ ORDER BY c.accno
+ ) AS taxkey,