Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL query problem when a column is null. Returns empty or cartesian
Hi there I am new to SQL. I am making a simple employee phonebook with tables employee, job, and department. (Employee is recursive in that it also stores the managers info.) My statement works as long as mgr_id is not null (employee table). When it is null an empty result set is returned - but...
