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 = ''

70-536 Passed :)