You are talking about filtering issue before inserting course in a table. But trigger has to do with only on insert, delete and update. Your problem seems to be more on select statement that filters whether the person is allowed to register or not. Hence, trigger has nothing to do with filtering. Trigger is table specifie for on insert, delete and update. May be I did not understand your problem statment