Sql Help

PWYNN · #1 (**permalink**) 03-31-04, 16:55

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

Pat Phelan · #2 (**permalink**) 03-31-04, 19:01

Maybe you wanted:

PHP Code:


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

and (JOBPLAN.JPNUM LIKE '%RJP%' ))

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech