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 Chris Miller 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. ttiiffffnnhh22000022

    Show a zero value if no value is found

    I am trying to display all JPNUMS and it's count of labor and tasks. They query below is only showing JPNUMS where there is labor and tasks however I want to show the JPNUMS where labor and/or tasks are also zero. SELECT JP.JPNUM, JP.STATUS, JPT.TASKCOUNT, JPL.CRAFTCOUNT FROM (SELECT JPNUM...

Part and Inventory Search

Back
Top