- ( 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,
-
- ( SELECT comma(taxdescription || to_char (rate, '99V99' ) || '%')
- 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 taxdescription,
-
- ( SELECT comma(taxnumber)
- 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 taxaccount,
-
- ( SELECT comma(tk.pos_ustva)
- FROM taxkeys tk
- WHERE tk.chart_id = c.id
- ORDER BY c.id
- ) AS tk_ustva,
-
- ( SELECT comma(startdate)
- FROM taxkeys tk
- WHERE tk.chart_id = c.id
- ORDER BY c.id
- ) AS startdate,
-
+ comma(tk.startdate) AS startdate,
+ comma(tk.taxkey_id) AS taxkey,
+ comma(tx.taxdescription || to_char (tx.rate, '99V99' ) || '%') AS taxdescription,
+ comma(tx.taxnumber) AS taxaccount,
+ comma(tk.pos_ustva) AS tk_ustva,