oop - my bad. sorry MD!
>Um Christopher, please remember while you are working on that laptop,
>that you might be logged in as me when you go to House Of Fusion
>(among other web sites).
>
>Secondly, I've heard about this issue before, but have never experienced the
>the problem. That's not to
Ah Ha! I figured out the problem with the query. This following seems to work
as expected:
SELECT
dbo.tblSubscribers.SID,
dbo.tblSubscribers.Username,
max(dbo.tblUserTransactionLog.Processed) AS LastTransaction
FROM
dbo.tblSubscribers,
dbo.tblUserTransactionLog
WHERE
Hello again Janet...
I am so sorry to be bugging you again on this, but I am having trouble with
this new query - not doubt it's something I just don't understand.
If I set the dates in this query to 08/01/2007 and 08/02/2007 I only get
results from 08/01/2007. And, if I have them both set to
Hello again Janet, thank you for your help on this. It suare has had me
stumped.
So, like this?
SELECT
dbo.tblSubscribers.SID,
dbo.tblSubscribers.Username,
max(dbo.tblUserTransactionLog.Processed) AS LastTransaction
FROM
dbo.tblSubscribers,
dbo.tblUserTransactionLog
WH
Hello Janet - thanks for the reply.
I should have mentioned that I need to get only the most recent transaction for
each user within the given time-frame. That's why I am using max(). Using
this aggregate function, I think, requires I use "having," no?.
Thanks, CWB
>Use the WHERE not HAVING
5 matches
Mail list logo
