Results 1 to 2 of 2

Thread: Sql Help

  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Sql Help

    WHERE exists (select JPNUM from MAXIMO.JOBLABOR where ((LABORHRS like '0')) and (JOBPLAN.JPNUM LIKE '%RJP%' ))

    this runs gives me no errors but it does not take in to account the laborhrs like '0'

    any ideas?
    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Maybe you wanted:
    PHP Code:
    WHERE exists (select JPNUM from MAXIMO.JOBLABOR where ((LABORHRS like '0%')) 
    and (
    JOBPLAN.JPNUM LIKE '%RJP%' )) 
    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •