表A左连接（表的子集）表B.

I want to left join TableA to TableB where a certain condition in tableA is true So I do this type of SQL queryI want to left join TableA to TableB where a ce