Inserting data from multiple tables

[andi_g69]

Only way I see is to use a UNION to combine both selects into one insert statement

If you just want to simply the code you could create a view doing the select from both source tables and then do your insert as:

INSERT INTO [tblInvoices]
(full_period,
account_code,
tran_amount,
function,
capital,
revenue,
misc,
source)
SELECT
full_period,
account_code,
tran_amount,
function,
capital,
revenue,
misc,
source
FROM yourView