Pages

Monday, September 15, 2014

Delete from data select in SQL Server


Delete from data select

example :

delete   tm_access_det from tm_access_det
inner join tm_access_hdt a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=20285
and SEC_DEPARTMENT='QC'

No comments:

Post a Comment