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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bullits

    SQL query problem when a column is null. Returns empty or cartesian

    Thanks for the help everyone. I should have mentioned it's mysql I am using. PHV's answer works straight away. IsNull(e.mgr_id,""), gives an error on mysql - is there an equivalent to use? Thanks again
  2. Bullits

    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...

Part and Inventory Search

Back
Top