Hi All,
I have one table namely app_users with fields(username,password,emai,phno,address) and one more table add_users with fields (uname,name,phno,email,status).
If email address is already exists in app_users table,then i should make the status column in app_users as"available"otherwise "notavailable".
here uname is foreign key for username,which is primary key in the table "app_users"
can anyone tell me the query to set the statuscolumn in add_users table?
Thank you in advance,
Regards,
Suma.