Usages of
select jd.SystemID, jd.SchedularID, jd.jobid from jobsmasterdetail jm, jobdetails jd, jobsmaster j where jd.jobtypeid = 10063 and jd.status = 0 and jd.SchedularID = jm.SchedularID and j.schedularid=jd.schedularid and jm.siteid=jd.siteid and jd.siteid= 1
None