ITNinja

Would someone please give me a hand with a report I have been fighting with? I simply need to generate a detailed patching report for a specific label. What was requested of me is that for each patch, it would show the patch status for all computers that are assigned to a specific label. I was able to get the report to run for all computers in my domain, but when I try to add narrow the SQL down to a specific label, things go sour.

I took this logic (that works but is not specific to a particular label):

select P.TITLE AS PatchName, MACHINE.NAME as ServerName, IP, S.STATUS
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P
where
MACHINE.ID = S.MACHINE_ID and
S.PATCHUID = P.UID and
P.IMPACTID = 'CRITICAL'
order by P.TITLE

And tried to insert label logic...so this part is what needs help. I am receiving: mysql error: [1054: Unknown column 'Label.Name' in 'field list'

select P.TITLE AS PatchName, MACHINE.NAME as ServerName, Label.Name, IP, S.STATUS
from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P, MACHINE_LABEL_JT, LABEL
where
MACHINE.ID = S.MACHINE_ID and
S.PATCHUID = P.UID and
P.IMPACTID = 'CRITICAL' and
MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID and
MACHINE_LABEL_JT.LABEL_ID = Label.ID and
Label.Name = 'Application Servers'
order by P.TITLE

I break on PatchName. Is there something dumb I am overlooking? SQL and I have a strained relationship.

Thanks for any and all help!
Mike