Posted by: ayhan | 11/10/2011

SQL Update’te INNER JOIN Kullanım Örneği

UPDATE C
SET
[EmergencyContactFirstName] = EC.[FirstName],
[EmergencyContactLastName] = EC.[LastName],
[EmergencyContactRelationship] = EC.[Relationship],
[EmergencyContactEmail] = EC.[Email],
[EmergencyContactMobilePhone] = EC.[MobilePhone],
[EmergencyContactHomePhone] = EC.[HomePhone],
[EmergencyContactWorkPhone] = EC.[WorkPhone]
FROM Contacts C INNER JOIN EmergencyContacts EC ON C.Id=EC.ContactId

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: