You will have to run this from Query Analyzer or MS Query, not the ISDEV
or SQL Server Query Designer tool.
Sincerely,
Anthony Thomas, MCDBA, MCSA
-----Original Message-----
From: Renga
[mailto:mssqldba-ezmlmshield-x97616294.[Email address protected]
Sent: Thursday, July 29, 2004 8:39 PM
To: LazyDBA Discussion
Subject: Update Query with Inner join
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
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************
MS Sql Server LazyDBA home page