SQL - Update one table from another.

Results 1 to 2 of 2

Thread: SQL - Update one table from another.

  1. #1
    Persesus Guest

    Default SQL - Update one table from another.

    A complicated Question here.<BR><BR>How do I update a table, with values from another table using SQL.<BR><BR>EG.<BR><BR>In one table say I have two fields: ID, Desc<BR><BR>In another say I have Three Fields: ID, Name, Desc<BR><BR>What I want to do is: Update Table2 Setting The Desc&#039s to Equal those of Table1 Where the ID&#039s are the Same.<BR><BR>?<BR><BR>Any help would be very useful.<BR><BR>Thanks<BR>Persesus.

  2. #2
    Persesus Guest

    Default More Info for you.

    In Access you can do <BR><BR> UPDATE Table1 INNER JOIN...<BR><BR>In SQL Server you cannot<BR><BR>Is there an Alternative?

Posting Permissions

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