FLUX Left join template

Hey Anaias,

Sure, so my questions are as follows:

Question 1: How to left join two tables and keep all columns from both the tables in FLUX? In the SQL version it’s simply select a*, b* from A left join B on A.id = B.id. How do we do the same in FLUX?

Question 2: For Query two, I have seen you use with in the as parameter of the join.left function. For instance here in 27793.
I’m want to make sure I have strict understanding of the syntax here, why is there with in some code and in others it’s not?