Friends

Tuesday, May 24, 2011

Inner join in update query

update tbl_document set isPaid=1 from tbl_document D
inner join tbl_transcription TR on TR.tran_id=D.tran_id
where TR.user_id=@user_id

No comments:

Post a Comment