By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

How to update one sql table from another table

P: 4
Hi all,

I have 2 tables table1 and table2 both is having same fields name,class,result,email. I will take email as the relational field, now i need to update the date of table1 from table2 condition is i need to check all the field of table1 (name,class,result) if any of the field is NULL then i need to update from table2 otherwise no update.

Can anyone please help me............


Thanks
Aug 4 '09 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
What do yo have so far?


--- CK
Aug 4 '09 #2

P: 4
Only 2 tables and a form in c.net. In form i displayed 2 checkbox in front of everyfield one checkbox is "always" and other is "only if NULL" if user select always then it will replace the value of this particular field with othe table value and if user select only if null then the system will check if the value for that particular field is null then it will take the value from second table otherwise it will keep the same value. I have 25 fields in my table and every field is having its own 2 check boxes..
Aug 4 '09 #3

ck9663
Expert 2.5K+
P: 2,878
I mean on the SQL Server side. What code do you have on your UPDATE part.


--- CK
Aug 4 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.