Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Access SQL problem

    I am not a sql person by any means but i need to write a little query. I can do it in Access real easy but it will not work outside of access.
    any help would be greatly appreciated.

    here is the statement
    SELECT MAXIMO_JOBLABOR.JPNUM, MAXIMO_JOBLABOR.LABORHRS
    FROM MAXIMO_JOBLABOR
    WHERE (((MAXIMO_JOBLABOR.JPNUM) Like "*RJP*") AND ((MAXIMO_JOBLABOR.LABORHRS)=0));

  2. #2
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    use % instead of * for Oracle SQL... Like so will work fine:

    SELECT JPNUM, LABORHRS
    FROM MAXIMO_JOBLABOR
    WHERE JPNUM Like '%RJP%'
    AND LABORHRS=0;
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    that works great in toad. but i need to do it in maximo. here is a sample of what maximo wants

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

    and this works but it returns all rjp's and does not take in account the laborhrs like '0'

    any idea's
    thanks

Posting Permissions

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