|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 5th, 2006, 09:26 AM
|
|||
|
|||
|
Replacing columns in one table with column values from another table
I have three columns in table1 out of which one is a primary key . The remaining two columns contains abbreviation of cities which needs to be replaced with the full name of the cities.
The second table is the look up table which contains expansion of the corresponding abbreviations present in the table1. how do i write the query ?
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Replacing columns in one table with column values from another table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
