Update Two Table With One Query

[khosroanjam]

سلام

چه طوری میشه دوتا جدول را که به هم Relation دارند رو با یک Query ی Update کرد

Inner Join For Select Query Is :

SELECT * FROM dbo.tbCitizeCharging inner join dbo.tbChargingType ON ChargingTypeID = dbo.tbChargingType.ID

[in_chand_nafar]

ترکیب Update و Join امکان پذیر است
http://stackoverflow.com/questions/982919/sql-update-query-using-joins
http://www.mindfiresolutions.com/How-to-use-UPDATE-with-JOIN-in-SQL-queries-691.php
http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql