Oracle 21c

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

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE books ( id, title, price, authorid ) AS
  SELECT 1, 'How to cook 4 humans', 42, 1 FROM DUAL UNION ALL
  SELECT 2, 'Mannequin Maintenance: For Dummies', 3.99, 2 FROM DUAL;
2 rows affected

CREATE TABLE authors ( id, givenname, othernames, familyname, home ) AS
SELECT 1, 'A', 'Large', 'Monster', 'Cave' FROM DUAL;
1 rows affected

SELECT b.id,
       b.title,
       b.price,
       t.tax,
       i.inc,
       a.givenname,
       a.othernames,
       a.familyname,
       a.home
FROM   books b
       CROSS JOIN LATERAL(SELECT price*0.1 AS tax FROM DUAL) t
       CROSS JOIN LATERAL(SELECT price+tax AS inc FROM DUAL) i
       LEFT OUTER JOIN authors a
       ON a.id=b.authorid;


ID
TITLE
PRICE
TAX
INC
GIVENNAME
OTHERNAMES
FAMILYNAME
HOME


1
How to cook 4 humans
42
4.2
46.2
A
Large
Monster
Cave

2
Mannequin Maintenance: For Dummies
3.99
.399
4.389
null
null
null
null


SELECT b.id,
       b.title,
       b.price,
       b.price * 0.1 AS tax,
       b.price * 1.1 AS inc,
       a.givenname,
       a.othernames,
       a.familyname,
       a.home
FROM   books b
       LEFT OUTER JOIN authors a
       ON a.id=b.authorid;


ID
TITLE
PRICE
TAX
INC
GIVENNAME
OTHERNAMES
FAMILYNAME
HOME


1
How to cook 4 humans
42
4.2
46.2
A
Large
Monster
Cave

2
Mannequin Maintenance: For Dummies
3.99
.399
4.389
null
null
null
null

ID	TITLE	PRICE	TAX	INC	GIVENNAME	OTHERNAMES	FAMILYNAME	HOME
1	How to cook 4 humans	42	4.2	46.2	A	Large	Monster	Cave
2	Mannequin Maintenance: For Dummies	3.99	.399	4.389	null	null	null	null