using :new and :old referencing different tables in SQL

using :new and :old referencing different tables in SQL

Revising for a uni exam. A question states:

Revising for a uni exam. A question states:

Write an SQL command to create a trigger in table Permission. The trigger should add one to the numberOfPermissions in table File for a file, after each time a new permission row is entered into table Permission with that file’s name.

here's a list of the tables provided

I've got everything down except one line, the WHERE line. How would I specify the :new value to a different table? It needs to read the new value as a the fileName column coming from the Permissions table, but I'm not sure how to do that. I've tried it in ways such as :Permissions.new.fileName etc but I always get an unspecified error around the "." point.

    CREATE TRIGGER newTrig
AFTER INSERT ON Permission
BEGIN
UPDATE File
SET numberOfPermissions = numberOfPermissions+1
WHERE File.name = :new.fileName
END;


Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts|Simpliv

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts

An Introduction to Oracle SQL

An Introduction to Oracle SQL: A quick tour of the six principal clauses of the SELECT statement.

Real time Oracle database administration interview questions | Simpliv

Real time Oracle database administration interview questions