ASP.net & SQL tutorials
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment