I need to simulate the left join effect without using the "left join" key.
I have two tables, A and B, both with
SELECT A.id, B.id
FROM A left join B
ON A.name = B.name
you can use this approach, but you must be sure that the inner select only returns one row.
SELECT A.id, (select B.id from B where A.name = B.name) as B_ID FROM A