SQL quiry help - simple

Cancelled

very simple help with a sql query

I want to update the passwords in table 1, with the passwords in table 2

Where table 1 ID = Table2 ID

for example the below did not work.

table1 = goth_users

table2 = goth_users___

UPDATE goth_users

SET [url removed, login to view] = [url removed, login to view]

FROM goth_users___ PASSWORD

WHERE [url removed, login to view] = [url removed, login to view]

Skills: SQL

See more: sql query help, simple sql update, sql server 2005 example quick insert update delete, update sql table, computer work order example, simple table sql, bcp sql server 2000 example, making delphi sql work windows work linux, sql work min server online counter strike, basic simple sample computer repair work order, computer service work order example, php simple script number hours work, sql backup vb6 example, simple sql query, query simple sql

Project ID: #5057217

77 freelancers are bidding on average $17 for this job

hits

Hello This is a simple requirement and I ensure a thorough job. I need both sql tables. I look forward to working on the project. Thanks Abha

$34 USD in 1 day
(91 Reviews)
7.0
ahtsolutions

Hi, We have experience with php and my sql. We did many sites, you can check my account or here: http://www.arrowhitech.com/portfolio/wordpress-projects Let me do it for you Thanks, David

$33 USD in 1 day
(8 Reviews)
5.1
kultech

Dear Sir, I have sql query done. Please contact with me, I have done it. I will show demo for you now Dear Sir, I can done a few hours. Please check history, i have do with you a project. Happy working wit More

$19 USD in 0 days
(4 Reviews)
4.4
tzo

Can help you on this. (==dummy message required==Please enter at least 100 characters.Please enter at least 100 characters.)

$15 USD in 1 day
(17 Reviews)
4.1
wesolvevw

Its very simple. It can be solved by just a join, can give you solution very faster. if your database is huge, can provide you the script for doing in batches if you need

$14 USD in 3 days
(28 Reviews)
4.1
elboukharimu

Hi, I'm very interested helping you creating your SQL query, I have years of experience in SQL and database administration, modelling, and manipulating, please do not hesitate to check my portfolio, there is some sampl More

$29 USD in 0 days
(8 Reviews)
4.0
yubor

MCSE, MCITP. 15+ years experience with sql,tsql,plsql... Yuri .

$15 USD in 1 day
(15 Reviews)
3.6
cheapexcell

mysql or ms sql ? can be completed in 5 minutes ============================================================

$15 USD in 1 day
(11 Reviews)
3.5
rabbul

Hi I am confident to do this job. ====================================================================== thanks

$24 USD in 1 day
(3 Reviews)
3.4
VjCoder

Hi! i am very good at SQL queries you can see my profile i have done 2 back to back projects on SQL queries and have satisfied my customer and am looking forward to satisy you with my work also... message me if interes More

$10 USD in 1 day
(3 Reviews)
3.5
NourElDeen

Dear Sir, I'm expert with sql, i can help you. Thanks, NourElDeen

$10 USD in 0 days
(10 Reviews)
3.4
outsourcedev

I can work on your project......... give me a chance to approve my self and I'm sure you will satisfied with my work results. We will ensure you that We will produce quality of work.

$15 USD in 3 days
(3 Reviews)
3.4
DeoTech

Hello. What SQL Server are you using? If it is - MS SQL - this is not very hard. I have more than 12 years experience in MS SQL Regards.

$35 USD in 1 day
(5 Reviews)
3.6
Dusan74

Hi, I` am MS SQL programmer with 10 + years of experience. Try this: UPDATE goth_users SET goth_users.PASSWORD = goth_users___.PASSWORD FROM goth_users INNER JOIN goth_users___ ON goth_users.ID = goth_users___ More

$10 USD in 1 day
(6 Reviews)
3.3
ahetel

Hi, I'm working with SQL Server for more than 10 years. Let's make that query to work and maybe more than this.. Best regards, Andrei Hetel

$15 USD in 1 day
(7 Reviews)
2.9
ramyrafik

Hello, I can help you with this very easily. I have the SQL statement ready and can send it once u accept the bid.

$14 USD in 0 days
(4 Reviews)
2.7
pivn

let expert do this https://www.freelancer.com/u/pivn.html https://www.freelancer.com/u/pivn.html https://www.freelancer.com/u/pivn.html

$30 USD in 0 days
(3 Reviews)
2.6
morff

Hi, i have checked your project description, and i understand what you want. I have strong knowledge of SQL and working update query for you ready already. Please let me know if the database is MySQL or other SQL datab More

$10 USD in 0 days
(2 Reviews)
2.3
evaxsoftvw

Hi, try this UPDATE goth_users SET goth_users.PASSWORD = (select goth_users___.PASSWORD FROM goth_users___ WHERE goth_users.ID = goth_users___.ID) Regards, Dmitry

$10 USD in 3 days
(1 Review)
2.2
nlancesl

I have good experience in SQL, T-SQL. I have done severa projects using sql. I can work on this project.

$10 USD in 0 days
(3 Reviews)
2.0