Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
select a.APPLIC_REF as ApplicantReference , a.FORENAME,a.SURNAME,a.BIRTHDATE, b.fromdate,b.untildate,c.JOB_NAME as jobname, c.COSTCENTRE,d.BRANCH, e.CHECK_DATE as CRBdate,e.CHECK_STATUS as CRBstatus,e.CHECK_RESULT as crbresult,e.CHECK_DATE as photodate, e.CHECK_STATUS as photostatus,e.CHECK_RESULT as photoresult,e.CHECK_DATE as meddate, e.CHECK_STATUS as medstatus,e.CHECK_RESULT as medresult, e.CHECK_DATE as OSPCdate, e.CHECK_STATUS as OSPCstatus , e.CHECK_RESULT as OSPResult from dbo.APPLIC a join dbo.APPLICANT_BACKGROUND e on a.APPLIC_REF=e.APPLIC_REF join dbo.APPVAC b on b.APPLIC_REF=a.APPLIC_REF and b.APPLIC_REF=e.APPLIC_REF join dbo.VACANCY c on c.VAC_REF=b.VAC_REF join dbo.LOCATION d on d.LOC_REF=c.LOCATION order by a.applic_ref
|SSRS Report Runtime Error||20||32|
|SQL Server 208R2 not recognizing DBF file in linked Server||11||30|
|Get row count of current SQL query||8||29|
|Why do I get extra rows when I do inner join?||12||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!