Consulta Tabla Cruzada

samardj · #1 (**permalink**) 13/04/2010, 15:11

Código:

SELECT   Jobs.JobTitle, Jobs.JobId, Jobs.Views, COUNT(submitals.jobid) AS Total_Submitals, submitals.checked, Contractor_profile.ContractorId, 
                      CheckedAppliedJobs.AppliedId
FROM         Jobs LEFT OUTER JOIN
                      submitals ON Jobs.JobId = submitals.jobid LEFT OUTER JOIN
                      Candidate_profile ON submitals.candidateid = Candidate_profile.CandidateId LEFT OUTER JOIN
                      Contractor_profile ON Candidate_profile.ContractorId = Contractor_profile.ContractorId LEFT OUTER JOIN
                      CheckedAppliedJobs ON Contractor_profile.ContractorId = CheckedAppliedJobs.ContractorID
WHERE     (Jobs.EmployerId = 1)
GROUP BY Jobs.JobId, submitals.checked, Jobs.Views, Contractor_profile.ContractorId, Jobs.JobTitle, CheckedAppliedJobs.AppliedId

huesos52 · #2 (**permalink**) 13/04/2010, 15:24

mmmmmmmmmm

gnzsoloyo · #3 (**permalink**) 13/04/2010, 17:59

¡Qué linda sentencia!
¿Y para qué sirve?

A menos que comentes algo de tu problema, la podemos imprimir y mandar a enmarcar.

... Perdón, pero no me pude resistir al chiste.

¿En qué consiste el problema?