How to Update from One table to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joshua A. Booker - 11 Nov 2005 19:50 GMT

Hi There,

How do I do this in an ADP?

UPDATE tbl_QuoteDates INNER JOIN Quotes ON tbl_QuoteDates.QuoteId =
Quotes.[Quote ID] SET tbl_QuoteDates.CustomerID = [Quotes].[CustomerID];

It appears as though the update statement cannot have joins? If so, then
how is this update done?

TIA,
Josh

Reply to this Message

giorgio rancati - 11 Nov 2005 20:11 GMT

Hi Josh

----
UPDATE tbl_QuoteDates
SET tbl_QuoteDates.CustomerID = [Quotes].[CustomerID]
FROM tbl_QuoteDates INNER JOIN
Quotes ON tbl_QuoteDates.QuoteId = Quotes.[Quote ID];
----

bye

Signature

Giorgio Rancati
[Office Access MVP]

> Hi There,
>
[quoted text clipped - 8 lines]
> TIA,
> Josh

Reply to this Message

Sylvain Lafontaine - 11 Nov 2005 20:13 GMT

The syntaxe is a little different between Access and SQL-Server. Try
something like:

UPDATE tbl_QuoteDates
SET tbl_QuoteDates.CustomerID = [Quotes].[CustomerID]
FROM tbl_QuoteDates INNER JOIN Quotes ON tbl_QuoteDates.QuoteId =
Quotes.[Quote ID]

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Hi There,
>
[quoted text clipped - 8 lines]
> TIA,
> Josh

Reply to this Message