|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
May 17th, 2004, 08:13 AM
|
|||
|
|||
Appending a table based on a matching condition between two tables
I am trying to append a field in table a from table b based on the criteria that column1 in table a and column 1 in table b contain the same data. Example:
Tablea, Column1 contains name tableb, column2 contains name tableb, column3 contains email address If tablea.column1 = tableb.column2 than replace tablea.column3 from tableb.column3 Can anyone help me with this?
|
|
#2
May 19th, 2004, 01:22 AM
|
|||
|
|||
|
So, where table1.col1 = table2.col2, update table1.col3 = table2.col3??
Code:
update Table1 set Table1.col3 = Table2.col3 from Table1 join Table2 on Table1.col1 = Table2.col2 where Table1.col3 <> Table2.col3 Last edited by Username=NULL : May 19th, 2004 at 01:53 AM.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Appending a table based on a matching condition between two tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
