SELECT NULL & NOT NULL Values 1

[REB0RN]

I'm trying to query SQL and pull back how many times a record appears in a table. This record may not appear.

SELECT tblMenuData.MENU_LINK, COUNT(tblIISLog.LOG_FILE) AS Expr1
FROM tblMenuData INNER JOIN
tblIISLog ON tblMenuData.MENU_LINK = tblIISLog.LOG_FILE
GROUP BY tblMenuData.MENU_LINK
ORDER BY tblMenuData.MENU_LINK

The problem I'm having is that the above query only pulls back records that are not null.

The first table shows all links in a menu. The second table shows the IIS Log.

I want to see a listing of all links and how many times they were clicked (If at all)

REBORN

Lunchlady Doris:
At last the world is safe. Eh fallout boy?
Ralph:
What's for lunch tommorrow? - NEXT
Chicken necks?

 

[JamesLean]

Change your join to a LEFT JOIN.

--James