Thanks for all your suggestions, I apparently had a brain cramp. Problem solved.
Thanks, Steve ----- Original Message ----- From: "Steve Osborne" <[EMAIL PROTECTED]> To: "MySQL (E-mail)" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 1:36 PM Subject: Query Question Additional Info > > I am trying to validate a user in a login form. > There are 3 things that must be true. > > User login name = email_login (from User table) > User password = password (from User Table) > User must be active: activeuser (from Owner table) = 'Y' > > The Owner table does have a common field with the User Table. (NameID) > > I don't know why I'm having so much difficulty with this SQL statement, but > can anyone help? > > Steve > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php