Notification Scheme Sql

[HaRsHaS' V]

I am trying to map notification schemes to events in Jira using SQL.

I am using this query. However, only events of few notifications appears others how  NULL.

Can anyone help out?

select * from notificationscheme ns
join notification n on ns.ID=n.SCHEME