For example:
The select A.a, a., A.c, B.a. A, B.b b from a a, b, where b...
I want to check A, B data in the table, but the B table there are two or more, I now need to check all the B table data, and then all additional behind A table of the data, the actual appearance should be the select A.a, a., A.c, B.a. A, B B.b, B.a a1, b1, B.b B.a a2, B.b b2,... How to write like this, you need to have a will?

CodePudding user response:

To have a union all below

CodePudding user response:

UNION ALL later merge using aggregate functions