HERE IS MY CODE

SELECT
A,
B,
C,
D,
E

FROM
(
SELECT
A,
B,
C
FROM VW1
GROUP BY A) Query1,

(SELECT
A,
D,
E FROM VW1
where week= (SELECT WEEK FROM CALNEDAR WHERE CALENDAR_DATE =( CURRENTDATE()-7))
GROUP BY A) QUERY2

WHERE
QUERY1.A= QUERY2.A

Now all rows are not being returned because the second query is briging back only records from last week.
I need an outer join and I am not able to place an outer join in the where clause