VSQL use distinct and Union all error solution:
Q1: What is the cause of the error in using DISTINCT in VSQL?
This is usually the case when a select DISTINCT field has an alias and the alias name is different from the original field name.
The processing method is also very simple, is to wrap another layer of query outside.
Note: The order by statement should be placed in the outermost layer.
Q2: What if VSQL fails to use union All?
Write and error as follows:
Due to the algorithmic logic of VSQL, when using union All, you need to package another layer of query outside.
Note: For union all subqueries, please do not write select *, because the order of the fields found by SELECT * cannot be controlled, so that the result sets of the former and the latter subqueries cannot match one by one.
END
This is the Silver Bullet Valley zero code software development kit
VSQL uses distinct and Union All to report the entire content of the error solution
I hope I can help the partners in need
I’ll see you next time