ScottPletcher (7/28/2016)
Probably the easiest way is to use derived tables within a main query, like below, assuming that each derive table returns only a single row:
SELECT q1.*, q2.*, q3.* --, ...
FROM (
SELECT ..., ...
FROM ...
) AS q1
CROSS JOIN (
SELECT ..., ..., ..., ...
FROM ...
) AS q2
CROSS JOIN (
SELECT ...
FROM ...
) AS q3
Thanks a lot ScottPletcher .. it worked