Re: Update Query

From: "Jon Jacobs" <JonJacobsAtcomcast.net>
Date: Sun, 15 May 2005 12:18:17 -0500

Thanks! That worked! (with: on D1.B = B2.B, which is what you probably meant).

Jon

>This syntax should work for SQL server and Access
>
>Update Table1
> Set C = D2.c
>>From Table1 D1 join Table2 D2 on D1.A = D2.B
>--
>Brian Bushay (TeamB)
>Bbushay@xxxxxxxxx
.

References:
- Update Query
  - From: Jon Jacobs
- Re: Update Query
  - From: Brian Bushay TeamB

Prev by Date: Re: ADO Stored procedure name
Next by Date: Re: ADO Stored procedure name
Previous by thread: Re: Update Query
Next by thread: Connecting to a server without a database
Index(es):
- Date
- Thread

Relevant Pages

Re: TADOTable.IndexDefs Problem
... IndexDefs is not supported for TadoTable. ... Brian Bushay (TeamB) ... Prev by Date: ...
(borland.public.delphi.database.ado)
Re: Pb while closing ADO query
... > Search your hard drive and see if you can find multiple copies of this ... > Brian Bushay (TeamB) ... Prev by Date: ...
(borland.public.delphi.database.ado)
Re: Field width
... In SQL server the following code will populate AdoDataset1 with the field ... Brian Bushay (TeamB) ...
(borland.public.delphi.database.ado)
Re: Send recordset as variable
... >when calling the function??? ... Brian Bushay (TeamB) ... Prev by Date: ...
(borland.public.delphi.database.ado)
Re: Open a query getting 0 record
... a where clause that evaluates to false is the only way ... Brian Bushay (TeamB) ... Prev by Date: ...
(borland.public.delphi.database.ado)