emp_id = Request.Querystring("emp_id")
Sql4="delete from send_mail where emp_id="& emp_id
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("test_project_update.mdb"))
set rs4=conn.execute(sql4)
Sql="delete from employee where emp_id="& emp_id
set rs=conn.execute(sql)
Sql2="delete from user where id="& emp_id
set rs2=conn.execute(sql2)
Sql3="delete from extra where id_extra="& emp_id
set rs3=conn.execute(sql3)
response.redirect "employee.asp"
%>
--------------------------------------------------------------------------------------------
relation คือ table emploeee เชื่อมกับ user ด้วย id
Load balance : Server 05
