13/04/2010, 15:11
|
| | | Fecha de Ingreso: marzo-2009
Mensajes: 120
Antigüedad: 15 años, 10 meses Puntos: 1 | |
| Consulta Tabla Cruzada
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
|