SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE invoices
(
invoice VARCHAR(20) NOT NULL,
id INT NOT NULL,
);
INSERT invoices(invoice, id) 
VALUES ('in20210110', 1);
INSERT invoices(invoice, id) 
VALUES ('in20210111', 2);
INSERT invoices(invoice, id) 
VALUES ('in20210112', 3);

CREATE TABLE positions
(
position VARCHAR(20) NOT NULL,
quantity INT NOT NULL,
price INT NOT NULL,
summ INT NOT NULL, 
invoice INT NOT NULL,
);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000001', 2, 100, 200, 1);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000002', 3, 100, 300, 2);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000003', 1, 250, 250, 2);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000004', 2, 120, 240, 1);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000005', 4, 100, 400, 1);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000006', 3, 100, 300, 1);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000007', 5, 80, 400, 3);
INSERT positions(position, quantity, price, summ, invoice) 
VALUES ('p1000008', 5, 100, 500, 3);

CREATE TABLE accounts
(
account INT NOT NULL,
invoice INT NOT NULL,
);
INSERT accounts(account, invoice) 
VALUES (01, 2);
INSERT accounts(account, invoice) 
VALUES (02, 2);
INSERT accounts(account, invoice) 
VALUES (03, 1);
INSERT accounts(account, invoice) 
VALUES (04, 3);
INSERT accounts(account, invoice) 
VALUES (05, 1);
INSERT accounts(account, invoice) 
VALUES (06, 3);

SELECT
positions.position, positions.quantity, positions.price, positions.summ,
invoices.invoice,
accounts.account

FROM
positions
INNER JOIN
invoices invoices ON invoices.id = positions.invoice
INNER JOIN
accounts accounts ON invoices.id = accounts.invoice

position	quantity	price	summ	invoice	account
p1000001	2	100	200	in20210110	3
p1000001	2	100	200	in20210110	5
p1000002	3	100	300	in20210111	1
p1000002	3	100	300	in20210111	2
p1000003	1	250	250	in20210111	1
p1000003	1	250	250	in20210111	2
p1000004	2	120	240	in20210110	3
p1000004	2	120	240	in20210110	5
p1000005	4	100	400	in20210110	3
p1000005	4	100	400	in20210110	5
p1000006	3	100	300	in20210110	3
p1000006	3	100	300	in20210110	5
p1000007	5	80	400	in20210112	4
p1000007	5	80	400	in20210112	6
p1000008	5	100	500	in20210112	4
p1000008	5	100	500	in20210112	6