How does this SQL write?

How does this SQL write?

Reply to discussion (solution)

SELECT * from A LEFT join B on A.id=b.id;

SELECT * from a b where a.id=b.id

SELECT a.id as ' aid ', a.name as Aname, b.p_id as PID, b.id as bid, b.session as bsession from B, WHERE a.aid=b.bid

SELECT * from A LEFT join B on A.id=b.id;

To find out from table B that matches the session field
If you add where b.session = ' AAA
If you add this condition, there is no session field in table A to list the data in table B.

Selact * from a LEFT join (SELECT * from B where session= ' AAA ') T on A.id=t.id

