RE: Help with a SQL statement

2001-01-04 Thread bflynn
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

Re: Help with a SQL statement

2001-01-03 Thread Cami Lawson
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

Re: Help with a SQL statement

2001-01-03 Thread Deanna L. Schneider
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

RE: Help with a SQL statement

2001-01-03 Thread Andres
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

RE: Help with a SQL statement

2001-01-02 Thread Andres
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? -

Re: Help with a SQL statement

2001-01-02 Thread Greg Wolfinger
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 ---