Hi,

CavTitle
========
RecID Title
------ ------------
1 FreeHold-99
2 FreeHold-999
3 Lease-50

CaveatsData
============
RecID Title OTHERFIELDS
------ ------ -----------
1 <NULL> SOME DATAS
2 <NULL> SOME DATAS
3 <NULL> SOME DATAS

UPDATE CaveatsData SET CaveatsData.Title = CavTitle.Title
FROM CavTitle INNER JOIN CaveatsData
ON CavTitle.RecId = CaveatsData.RecId

I have two tables having RecId for relationship, Want to fill the
CaveatsData.Title when I run the aboce query, result is correct
but SQL server displays an error message.

"The Query Designer does not support the Optional FROM clause SQL
construct."

what the right syntax ? pls..

warm rgds,
P.Renga



MS Sql Server LazyDBA home page