Simple one really - I have some SQL, there is an inner join and a group by the inner join eg:
select count(*) AS Total, myTable.myField FROM myTable INNER JOIN myJoinedTable ON myTable.myField = myJoinedTable.myField GROUP BY myJoinedTable.fieldToGroupBy
At the moment it returns:
etc - but if there are any NULL values in the main table in fieldToGroupBy they get ignored. I cannot think of / find the syntax to just return another row for any null values (or values that do not match the joined table).
can any one fill me in?