How do i get my group by to show null values as well?

At the moment the following statement will discard the NULL rows:

SELECT e.empno, e.fname, e.lname, w.location, w.buildingno, w.floorno,
w.facilityno
FROM employee e LEFT OUTER JOIN
workarea w ON e.empno = w.empno
GROUP BY w.location, w.buildingno, w.floorno, w.facilityno;

Kindly regards,

Nav

write your query so that all non-aggregate columns in the SELECT list are in the GROUP BY

with the GROUP BY that you have, the columns e.empno, e.fname, and e.lname should be involved in aggregate functions, e.g.
this query at least makes syntactic sense, although semantically it's pretty useless

rudy
http://r937.com/