C
Crystal via AccessMonster.com
The following statements does not work on Microsoft SQL server. (ERROR msg:
Incorrect syntax near the keyword 'LEFT'.) But they work on Access (with
table names changed). Why? Thanks in advance.
UPDATE ##service LEFT JOIN ##coverage ON ##service.mem=##coverage.id
SET ##service.status = ‘Covered’
WHERE (##service.dt_filled) Between ##coverage.START_DT And ##coverage.END_DT)
;
Incorrect syntax near the keyword 'LEFT'.) But they work on Access (with
table names changed). Why? Thanks in advance.
UPDATE ##service LEFT JOIN ##coverage ON ##service.mem=##coverage.id
SET ##service.status = ‘Covered’
WHERE (##service.dt_filled) Between ##coverage.START_DT And ##coverage.END_DT)
;