Dbisam 3.27

what is wrong ?
two table "chiamate" and "clienti"
I need update chiamate.citta from clienti.citta value
Every "chiamate" have one and only one record in "clienti" table

Dbisam engine error # 11949 SQL error: right parenthesis expected, instead found 'clienti' in value expression


update chiamate
SET citta = (select clienti.citta
                 from clienti
                 where clienti.codice=chiamate.cliente )
WHERE citta = null

Thanks

cam

cam


You need to use a join - check the manual or in these newsgroups - I remember a similar posting within the last month.

Roy Lambert

Cam,

Use this instead:

UPDATE chiamate SET citta = clienti.citta
FROM chiamate INNER JOIN clienti ON clienti.codice=chiamate.cliente
WHERE citta = null

--
Tim Young
Elevate Software
www.elevatesoft.com

--

"Tim Young [Elevate Software]" >
> Use this instead:
>
> UPDATE chiamate SET citta = clienti.citta
> FROM chiamate INNER JOIN clienti ON clienti.codice=chiamate.cliente
> WHERE citta = null
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Hi Tim
Thank you
is very fine ! All OK !!!

cam