INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

update columns between two tables

update columns between two tables

(OP)


Hi
I have two tables with column A and column B. I want to update column B of table9 with column B of table1 .

table1
A | B
----|----
10 |12
14 |16

table9
A | B
----|----
1 |3
2 |4



I am trying this query in ms access from Vb.net. It pastes the column below the existing data


update table1 t1 LEFT JOIN table9 T9 on t1.a = t9.a SET t9.b = t1.b


table9
A | B
----|----
1 |3
2 |4
|12
|16

How do I write a update query that will replace the existing column like this?

table9
A | B
----|----
1 |12
2 |16

Thanks

RE: update columns between two tables

Based on your example:

table1
 A | B
---|----
10 |12
14 |16

table9
A | B
--|----
1 | 3
2 | 4
 
and your outcome:

table9 
A | B
--|----
1 |12
2 |16
 

What is you logic that
table1.A with 10 = table9.A with 1 ? 10 = 1?
table1.A with 14 = table9.A with 2 ? 14 = 2?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close