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?