Joining one to many relational table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "sqllearner" <sqllearner@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 3 Jun 2005 23:07:01 -0700

I have two tables: Table1 has A,A,B,B,B and Table2 has A, B. I want to join
Table1 with Table2 and update Table1, but I want to update only 1 for A and 1
for B in Table1. How will I do it?
.

Follow-Ups:
- RE: Joining one to many relational table
  - From: sqllearner

Prev by Date: Re: MCDBA SQL SERVER 2005 Requirements
Next by Date: RE: Joining one to many relational table
Previous by thread: Re: MCDBA SQL SERVER 2005 Requirements
Next by thread: RE: Joining one to many relational table
Index(es):
- Date
- Thread