SQL subqueries

A

Accessor

Hi all. I'm still struggling with subqueries a little bit. I'm trying to
combine two queries here. Both are pasted below and run seperately, the 2nd
is the source for the first. How do I combine them? (use the 2nd one as "FROM
(SELECT") is what I'm thinking.) Thanks in advance...

Kevin

INSERT INTO tblPointsOfInterest ( PointOfIntSymb, PointOfIntDateAdded,
PointOfIntQuery )
SELECT qryOptionsBigChgOpIntLatestDateWithCount.ChgOpenIntSymbol, Date() AS
Expr1, "OptionsBigChangeOpenInterest" AS Expr2
FROM qryOptionsBigChgOpIntLatestDateWithCount;

SELECT tblOptionsMostActiveYahoo.MostActiveSymb,
Max(tblOptionsMostActiveYahoo.MostActiveDateAdded) AS
MaxOfMostActiveDateAdded,
Count(tblOptionsMostActiveYahoo.MostActiveDateAdded) AS
CountOfMostActiveDateAdded
FROM tblOptionsMostActiveYahoo
WHERE (((tblOptionsMostActiveYahoo.MostActiveDateAdded
 
Top