On Wed, Jun 19, 2013 at 3:38 PM, Bill Downall <
[email protected]> wrote:

> UPDATE ClientMaster +
>   SET LastHomeVist = MaxVisitDate +
> FROM ClientMaster, *MaxVisitDates *h2 +
> WHERE ClientMaster.ClientID = h2.ClientID
>

Oops. FROM clause should have referenced the VIEW, not the table, as shown
in the edit above.

Reply via email to