That's an equivalent syntax. The only time the JOIN syntax produces a
different execution plan from the WHERE Clause syntax is in OUTER JOINs.
Sincerely,
Anthony Thomas, MCDBA, MCSA
-----Original Message-----
From: Parthasarathy Mandayam
[mailto:mssqldba-ezmlmshield-x72385913.[Email address protected]
Sent: Thursday, July 29, 2004 9:27 PM
To: LazyDBA Discussion
Subject: RE: Update Query with Inner join
try
UPDATE CaveatsData
SET CaveatsData.Title = CavTitle.Title
FROM CavTitle, CaveatsData
where CavTitle.RecId = CaveatsData.RecId
Regards
Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com
>From: "Carter Phillip "
><mssqldba-ezmlmshield-x22240290.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Update Query with Inner join
>Date: Fri, 30 Jul 2004 12:17:30 +1000
>Received: from www.websitesondatabases.com ([216.55.183.38]) by
>mc9-f34.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Thu, 29 Jul
2004
>19:18:01 -0700
>Received: (qmail 32298 invoked by uid 121); 30 Jul 2004 02:17:04 -0000
>Received: (qmail 28355 invoked from network); 30 Jul 2004 2:17:4 -0000
>X-Message-Info: JGTYoYF78jH92g+kdbY6yO/We6SKyEzS
>Mailing-List: contact mssqldba-[Email address protected] run by ezmlm
>Precedence: bulk
>X-No-Archive: yes
>List-Post: <mailto:[Email address protected]
>List-Help: <mailto:mssqldba-[Email address protected]
>List-Unsubscribe: <mailto:mssqldba-[Email address protected]
>List-Subscribe: <mailto:mssqldba-[Email address protected]
>Delivered-To: mailing list [Email address protected]
>Message-ID: <20040730021704.32296.[Email address protected]
>Return-Path: mssqldba-return-7388-MCP111=hotmail.[Email address
protected]
>X-OriginalArrivalTime: 30 Jul 2004 02:18:01.0267 (UTC)
>FILETIME=[70205030:01C475DB]
>
>Syntax looks ok. Are you trying to run this in Enterprise Manager??
>
>If so, try using Query Analyzer instead. It's not as helpful when
building
>queries, but it handles all the T-SQL syntax variations.
>
>
>Thanks
>Phillip Carter
>Ph: +61 3 9235 1691
>
>
>-----Original Message-----
>From: Renga [mailto:mssqldba-ezmlmshield-x97616294.[Email address
>protected]
>Sent: Friday, 30 July 2004 11:39 AM
>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]
>
>
>IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS:
>
>Because this document has been prepared without consideration of any
>specific clients investment objectives, financial situation or needs,
>a Bell Potter Securities Limited investment adviser should be
>consulted before any investment decision is made.
>
>While this document is based on the information from sources which
>are considered reliable, Bell Potter Securities Limited, its directors,
>employees and consultants do not represent, warrant or guarantee,
>expressly or impliedly, that the information contained in this document
>is complete or accurate.
>
>Nor does Bell Potter Securities Limited accept any responsibility to
>inform you of any matter that subsequently comes to its notice, which
>may affect any of the information contained in this document.
>
>This document is a private communication to clients and is not intended
>for public circulation or for the use of any third party, without the
>prior approval of Bell Potter Securities.
>
>
>Disclosure of Interest: Bell Potter Securities Limited receives
commission
>from dealing in securities and its authorised representatives, or
>introducers
>of business, may directly share in this commission. Bell Potter
Securities
>and its associates may hold shares in the companies recommended.
>
>Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No.
243480
>
>
>---------------------------------------------------------------------
>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]
>
---------------------------------------------------------------------
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