This should work: Select table2.* from table2 inner join table1 on (table2.fldusername = table1.userid) where table1.userid='" & sUserId & "' and where table2.fldDate > '" & CDate(Now() - 30) & "'"
-----Original Message----- From: jenksonu [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 12:51 PM To: [EMAIL PROTECTED] Subject: [ASP] asp search help I have a database with 2 tables. Table1.userid (a list of users) Table2.fldDate is a log of when users login. I use a dropdown list from table1.userid to see all the information in the log for that user. This is my statement I use now. Select table2.* from table2 inner join table1 on (table2.fldusername = table1.userid) where table1.userid='" & sUserId & But I would like to limit what I see by date. I just want to see the last 30 days. --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Sponsor ADVERTISEMENT <http://rd.yahoo.com/SIG=129ed3lbs/M=298184.5022502.6152625.3001176/D=groups/S=1705115381:HM/EXP=1086810670/A=2164339/R=0/SIG=11e2d64in/*http://www.netflix.com/Default?mqso=60183348> click here <http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164339/rand=853030271> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
