Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kiesh
Starting Member
6 Posts |
 Posted - 2009-11-15 : 23:17:35
|
| Trying to perform user registration here, but my user needs to be a qualified user of the system, and also register to use the system before. So during registration, if that user is not a qualified member to register, then he/she are not authorized to be able to use my system.I have a Users table- where when a user registers their info is stored thereI have a Members table- where it stores member info for those who can register to use the system.So i know i need a simple insert statement for the users table, but how do i get to check in that statement, that before the data is entered in Users, that the data exists in Members? Implying that the person registering can use the system, and be allowed to register.I hope someone understands...please help!Thank you. |
|
|
kiesh
Starting Member
6 Posts |
Posted - 2009-11-15 : 23:19:37
|
| btw i am strictly using mysql |
 |
|
|
|
|
|
Insert data in TableA only if data matches TableB