Reply
using update and inner join
Old 08-17-2006, 09:50 AM using update and inner join
numbenator's Avatar
Ultra Talker

Posts: 413
Location: London
Hi all

USING 1 QUERY, I wish to update fieldA in table 1 only on condition of a record being found in table 2.

How do i do this?

cheers

Steve
__________________
www.mastech-solutions.com
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
When You Register, These Ads Go Away!
Old 08-17-2006, 01:11 PM Re: using update and inner join
ColdFusion's Avatar
Extreme Talker

Posts: 222
Location: NY
Check out this discussion
UPDATE QUERY Using Enterprise Manager (SQL Server) - JodoHost Forums
ColdFusion is offline
Reply With Quote
View Public Profile Visit ColdFusion's homepage!
 
Reply     « Reply to using update and inner join
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.11080 seconds with 12 queries