|
CURRENT OPENINGS
SELECT job.state, job.city, job.date_posted, job.deleted, job.job_filled, job.show_job, job.title, job.job_iid, job.job_id, job.company, job.salary_range, job.hours_per_week, job.format, job.show_job, job.job_filled, job.date_filled, job.date_start, job.date_end, job.country, job.deleted, loc.show_jobs
FROM loc INNER JOIN job ON loc.loc_iid = job.loc_iid
WHERE (((job.deleted)=False) AND ((job.job_filled)=False) AND ((job.show_job)=True) AND ((loc.show_jobs)=True))
ORDER BY job.date_posted DESC;
No jobs are listed right now. Please try back again soon.
#GetJobs.title#
Job Id: #GetJobs.job_id#
Location: #GetJobs.city#, #GetJobs.state#
Salary range: #GetJobs.salary_range#
|
|
