hi, i'm here again to ask help regarding my problem with the view that i created. On my tblEvents there 8 records but i created the view it only displays 3 records. I'am suspecting that the view doesn't read a null value from my tblEvents. How do i fix this?
SELECT dbo.tblUsers.UserID,
dbo.tblUsers.UserFirstName + ' UserLastName' AS Author,
dbo.tblUsers.UserLastName,
dbo.tblUsers.UserEmailAddress,
dbo.tblEvents.EventID,
dbo.tblEvents.EventName,
dbo.tblEvents.EventDescription,
dbo.tblEvents.EventVenue,
dbo.tblEvents.EventDate,
dbo.tblEvents.AddedBy,
dbo.tblEvents.Pending,
dbo.tblEvents.DateAdded,
dbo.tblEvents.DateEditted,
dbo.tblUsers.UserName
FROM dbo.tblUsers
JOIN dbo.tblEvents ON dbo.tblUsers.UserID = dbo.tblEvents.EdittedBy