SQL Help

ericx1 · #1 (**permalink**) 01-17-12, 13:26

I have two tables tbl_Notification and tbl_EventNotification, joined together

tbl_Notification is a list table and tbl_EventNotification is a junction table between the list and main table.

tbl_Notification
NotificationID

tbl_EventNotification
EventID
NotificationID

Say I have 5 entries in tbl_Notification.

Home
Business
Cell
Fax
Email

And I have 2 entries for a specific EventID in tbl_Notification

Home "No Answer"
Cell "Bob"

What I want displayed is

Home "No Answer"
Business
Cell "Bob"
Fax
Email

Everything I have attempted to do has either only given me the two enteries or gives me entries from other EventID.

Can anyone help me with how to get this desired outcome with a SQL statement?

Thanks for your time, thoughts and knowledge!

r937 · #2 (**permalink**) 01-17-12, 14:33

use a LEFT OUTER JOIN

Code:

SELECT tbl_EventNotification.EventID
     , tbl_Notification.NotificationID
  FROM tbl_Notification
LEFT OUTER
  JOIN tbl_EventNotification
    ON tbl_EventNotification.NotificationID = tbl_Notification.NotificationID

ericx1 · #3 (**permalink**) 01-17-12, 15:15

Thanks for the reply works perfectly. Genius me forgot the "ON" portion of the sql syntax, I'm feeling smart today

Thanks for the time to answer a silly question!

Internet Services

Web Development

Digital Marketing

Consumer Tech