I have two different query result here:
- The result from mysql LEFT JOIN, which has empty columns,
- The result from query-json-with-sql LEFT JOIN, which has non-empty columns only.
version 1: query and result
(Shows both yellow and green, even if green side is empty)
version2: query and result
(Shows only yellow columns becuase green side is empty)
What I want to do is make a result like version1 (mysql) from query-json-with-sql. (To show both yellow and green columns even if green side is empty set)
When green side is not empty, version 1 and 2 shows the same result.
How could I do this? Any helps or hints would be very grateful.
The reason I want to use query-json-with-sql instead of mysql query is that I don't want to specify column names in query statements.
(In the empty set case, I found that the result from mysql shows null on key column)
Thank you in advance!