Results 1 to 2 of 2

Thread: How can I update 1 table using data from 2 tables?

  1. 05-11-2005, 05:18 AM #1
    superuser
    superuser is offline Registered User
    Join Date
    May 2005
    Posts
    2

    Question How can I update 1 table using data from 2 tables?

    How can I update 1 table using data from 2 tables?

    update table1
    set table1_field1 = 'con',
    table1_field2 = 'con2'
    where table1_field1 = 'aaa'
    and table2_field1 = 'bbb'


    Can anybody help me (or indeed understand the above!) PLEASE!


    __________________
    dodds
    Reply With Quote Reply With Quote
  2. 05-13-2005, 08:49 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    http://forums.databasejournal.com/sh...ble+using+data
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules