By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,341 Members | 1,619 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,341 IT Pros & Developers. It's quick & easy.

Count by date/id across tables??

P: n/a
I love it when I back myself into a corner. Seems to be the fastest way to
learn.

I have 3 tables; tblINBOX, tblOUTBOX and tblPENDING
The relevant rows are as following; Date, userID
userID is a 5 digit number

I understand how to construct a query to return a count of the userID for
a date range for a single table. I'm stumped on how to get a single query
that will give me the count of the userID for a date range.

I know this is basic stuff, but I could really use a hand.

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 15 Jun 2004 02:21:37 GMT, FatBoyThin <no****@botbait.gov> wrote:
I love it when I back myself into a corner. Seems to be the fastest way
to learn.

I have 3 tables; tblINBOX, tblOUTBOX and tblPENDING
The relevant rows are as following; Date, userID
userID is a 5 digit number

I understand how to construct a query to return a count of the userID
for a date range for a single table. I'm stumped on how to get a single
query that will give me the count of the userID for a date range.

I know this is basic stuff, but I could really use a hand.


Sorry, that should have read:
"I'm stumped on how to get a single query that will give me the count of
the userID for a date range for all three tables."

It's been a long day.
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.