Запросы: объединить результаты нескольких запросов в другом запросе в строчку

Р1: 1267
Р2: 3467
Р2: 3468
…
Р6: NULL (отсутствуют результаты)
Р7: NULL (отсутствуют результаты)
Р8: NULL (отсутствуют результаты)

Р1        Р2         Р3        Р4    Р5     Р6     Р7     Р8
1267    3467         3468        67       89      0       0        0

SELECT [Р1].Q, [Р2].Q, [Р3].Q, [Р4].Q, [Р5].Q, [Р6].Q, [Р7].Q, [Р8].Q
FROM Р1, Р2, Р3, Р4, Р5, Р6, Р7, Р8; 

SELECT Q as QBSI, 0 AS QBSN, 0 AS QALI,0 AS QALN,0 AS QDSI,0 AS QDAN,0 AS QGAI,0 AS QGAN from Р1
union all select 0, Q ,0,0,0,0,0,0  from Р2
union all select 0, 0,Q ,0,0,0,0,0  from Р3
union all select 0, 0,0,Q,0,0,0,0  from Р4
union all select 0,0,0,0,Q,0,0,0 from Р5
union all select 0,0,0,0,0,Q,0,0 from Р6
UNION ALL select 0,0,0,0,0,0,Q,0 from Р7
UNION ALL select 0,0,0,0,0,0,0,Q from Р8;

select "p1" AS p1, "p2" AS p2, ....
FROM p1
union
SELECT (select * from p1) AS p1, (select * from p2) AS p2, ...
FROM p1 order by p1 desc;