ging logdate to logid in the WHERE clause.
Brian
-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 4:54 PM
To: CF-Talk
Subject: RE: Help with a SQL statement
SELECT
teaserusers.userid,
teaseruser
teaserusers.userid = log_userstatus.userid
cami
- Original Message -
From: "Andres" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 03, 2001 8:44 AM
Subject: RE: Help with a SQL statement
> Heather,
> I will try this, and con
I haven't seen anyone answer this, so here goes - try adding the group by
statement. Also, indicate what you really want from the log_userstatus
table. If all you want is the date, just select that (and add it to the
group by clause).
SELECT
teaserusers.userid,
teaserusers.nickname,
teaserusers.f
Heather,
I will try this, and continue building upon it.
thanks for your help!
andres
-Original Message-
From: Heather Haindel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 7:35 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with a SQL statement
I am trying to figure this
ho ARE NOT listed in the
"log_userstatus" table.
Am i way off?
thanx!
andres
-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 02, 2001 4:54 PM
To: CF-Talk
Subject: Re: Help with a SQL statement
Can we see your current SQL statement?
-
Can we see your current SQL statement?
--Greg
- Original Message -
From: "Andres" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 4:42 PM
Subject: Help with a SQL statement
> I need some help with a sql statement:
> I have two tables:
>
> 1 ---
6 matches
Mail list logo