Re: Joining one to many relational table

"sqllearner" <sqllearner@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@xxxxxxxxxxxxxxxx
>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?


Are A,A,B,B,B values for one column across 5 rows in Table1? Are there other
columns in Table1?

For the joins, SELECT DISTINCT might be an option. For the update, I need
more info.

Also, to use a New York phrase: Not for nothin', but this is the MCSE group.
You might have a bit more luck with one of the SQLServer groups.

--
Mike T.
MCNGP #XLI


.

Relevant Pages

  • Dynamic Variables?
    ... I want to make both of the entries at the same ... to be sent with the rest of the data to table2. ... INSERT INTO table1 ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Update/Append AND Delete combination?
    ... common field from Table1 must be updated FROM ... Table2 for a particular column?? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: VFP9 Multiple table Report Question
    ... > TABLE1 TITLE ... > TABLE2 TITLE ... > How can I print the records of two tables in a single VFP9 Report? ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Filling a muti-table typed dataset using a stored procedure
    ... Table1. ... The third one is Table2 and so on. ... Now, if you change you table names into tblEvent and tblEventType, you can ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • not in query
    ... I need a query to show records in table1 that are not in table2. ... Prev by Date: ...
    (microsoft.public.access.queries)