Are Innerjoins Updatable??

[dvannoy]

I am using VB as a front end to SQL server...if I pull up a recordset using and Inner Join statement, are inner joins updatable??

Thanks

 

[SQLSister]

The answer to your question is a firm yes and no! Yes, you can use a join in an update to define which records to update. No you cannot update both tables at the same time. Updates also depend on constraints on the tables and often have to be done in a specific order due to the realtionships between the tables.
While you can't write one update statement, you can put both update statement si n one stored procedure or trigger.

 

[malexanian]

I think dvannoy means using an inner join within a view to create a dynaset. These are not necessarily updateable... It depends on the join and on the particular field. Look it up Books Online. Let's just say SQL Server is much more restrictive than Microsoft Jet.