tecneck
A place to collect and structure thoughts of the art of computer science.
Thursday, 5 November 2009
SQL update with INNER JOIN
Just a reminder to self:
update ICD
set ICD.if1_deleted = 'Y'
FROM
IF1_FILE as ICD INNER JOIN ID1_FILEDET ON IF1_ID = ID1_PARENT
and ID1_NAME =
and ID1_VALUE = ''
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment