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