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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Select Top with aggregate function 1
Query help - creating chart 0
Compare results of two expressions within query 1
Question about Queries with Subqueries 1
trying to create a sample table with 31,000,000 rows 6
Replace Parentheses with Bracket in Subquery 1
Append Union Queries 2

Top