How to get unread notifications (2 tables with FK)


I have 2 tables on my DB: user_notification and user_notification_read. It's a user notification system the notifications are on user_notification and when a user reads a notification it stores on user_notification_read with the notification id and the user id.

CREATE TABLE `user_notification` (   `id` int(11) NOT NULL AUTO_INCREMENT