jeudi 30 mars 2017

how can I select only all done Task in MYSQL?

I am doing a simple task in MYSQL . As Example , There is Jib(jobId) and subjid(subJobId) and UL. SubJobId is a Id refereed to JOBID and each SubJID has a ul field , I Only need those JID(JobId) whose UL is 1, if there is even 1 UL is 0. then it'll ignore.

please check the image enter image description here

Aucun commentaire:

Enregistrer un commentaire