Updating Records in Multiple Tables

I already know how to upate records in multiple tables via recordsets. I would like to know how to update records in multiple tables using a stored procedure. I am not exactly sure how you could do this.

Here's my code:

strSql = "Update DomainName Set DomainName=@DomainName, Registrar=@Registrar,ExpirationDate=@ExpirationDat e, BusinessName=@BusinessName, ClientID=@ClientID From DomainName D Join Clients C On D.ClientID=C.ClientID Where DomainNameID=@DomainNameID"
cmdSql = New SqlCommand( strSql, conDomainName )
cmdSql.Parameters.Add( "@DomainName", strDomainName )
cmdSql.Parameters.Add( "@Registrar", strRegistrar )
cmdSql.Parameters.Add( "@ExpirationDate", ExpirationDate)
cmdSql.Parameters.Add( "@BusinessName", BusinessName)
cmdSql.Parameters.Add( "@ClientID", intClientID)
cmdSql.Parameters.Add( "@DomainNameID", intDomainNameID )

BusinessName is from the Clients Table. The other fields are from the DomainName Table.

Can someone please help me with this?

You never want to do updates with JOINs in them, you can get unpredictable results.
You should only update a single table at a time and update the specific row based on the tables primary key.