How to update a view with two detail table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a view, it is create by one primary table and two detail tables, like

SELECT St.GuyID,
WH.Weight,WH.Height,
Sight.SightL, Sight.SightR
FROM St,WH, Sight where
WH.GuyID = St.GuyID and Sight.GuyID = St.GuyID

I was use this select statement in a SqlDataSource.
How can I write the update statement for it?


.

Relevant Pages

  • Re: Trigger For DateTime
    ... Awesome Erland, thanks that's what I was looking for! ... I've never seen a FROM / JOIN on an update statement before. ... you could alias the table to save typing? ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: Cool Query Analyzer Trick
    ... update statement, press Ctrl-Shift-M... ... Jacko ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)
  • Re: help
    ... an update statement instead of select ... Thanks & Regards ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Updating a column in a DataTable...
    ... Ok, I'm sure this one has been asked before, so I'll apologize upfront. ... What I'd like to do is take a DataTable and run an update statement against ... a DataAdapter, or is it not that simple? ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Newbie needs help with "yes/no" field
    ... > Here is my update statement, ... > fRandomPassword & ... What SQL does this produce? ... Prev by Date: ...
    (microsoft.public.inetserver.asp.db)