SQL UPDATE error on subselect with more than one row returned

The following SQL errors with

"Result of SELECT more than one row."

This makes sense because there is more than one row returned by the subselect.

How I can tell SQL to only use the FIRST row returned by the subselect?




update rjsimage/docs00 a
set keyword3 =
(select first scaletix from jstone/docs00fix2 b
where a.docid = b.docid
FETCH FIRST 1 ROW ONLY)
where exists
(select first scaletix from jstone/docs00fix2 b
where a.docid = b.docid
FETCH FIRST 1 ROW ONLY)




I tried FETCH FIRST 1 ROW ONLY as below but it returned error "Keyword FETCH not expected."

Any other ideas?

Thanks!


update rjsimage/docs00 a
set keyword3 =
(select first scaletix from jstone/docs00fix2 b
where a.docid = b.docid
FETCH FIRST 1 ROW ONLY)
where exists
(select first scaletix from jstone/docs00fix2 b
where a.docid = b.docid
FETCH FIRST 1 ROW ONLY)

______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________