How to display NULL if there are no rows?

Question

Oracle

Experienced comrades, we need your help. There is the following scheme:

There is a request:

SELECT t.id         AS "ID",
       t.val        AS "VALUE",
       te.ext_val   AS "EXT_VALUE",
       t.val * 2,2  AS "RATED VALUE"
FROM   table_main t
JOIN   table_ext te ON t.id = te.id
WHERE  t.id = &id
AND    t.val > 0
AND    te.ext_name = 'ADD_ATTR'

Example data:
table_main :

id  |  val
-----------
1      100
2      150

table_ext ;

id  |  ext_name     |  val
---------------------------
1	ADD_ATTR     200
1	ADD_VAL      5
2       ADD_VAL      10

In the event that the condition te.ext_name = 'ADD_ATTR'is not met, i.e. there are no such records, the query returns an empty set. How can I change the query so that it fills in a field te.ext_val AS "EXT_VALUE"in the resulting table as NULL in this case?
Thanks in advance.
PS LEFT JOIN does not work in this query

Answer 1

LEFT JOIN `table_ext` AS `te` ON `te`.`id` = `t`.`id` AND `te`.`ext_name` = 'ADD_ATTR'

Answer 2

LEFT JOIN