Help !create a triggers in sql server

[junelle22]

Guys ! I need your help......

Meron akong 4 tables.
Project=code,title,manager,budget
employee=employee no,employee name
department=department no,depart name
hourly rate=hrate
@tapos ko na yan nagawa lahat na tables ang problema ko lang paano gawan ng triggers na maisa lang sya pero kailangan na merong log table ...paano gawan ng triggers na bawat table mag join??thanks po sa may alam ....

 

[bdalina54]

CREATE VIEW

gawa ka ng SQL Table View

 

[rhonrsv]

Guys ! I need your help......

Meron akong 4 tables.
Project=code,title,manager,budget
employee=employee no,employee name
department=department no,depart name
hourly rate=hrate
@tapos ko na yan nagawa lahat na tables ang problema ko lang paano gawan ng triggers na maisa lang sya pero kailangan na merong log table ...paano gawan ng triggers na bawat table mag join??thanks po sa may alam ....

SELECT (Columns from your table1)
FROM [table1] JOIN Columns na isasama mo from other table
ON [table2].column=column

just try to play the query