SELECT j.id, u.first_name AS f_contact, u.last_name AS l_contact, e.email, fnum.phone AS fax, pnum.phone AS phone, addr.street AS addr1, addr.city AS addr2, addr.state AS addr3 FROM jb_jobs AS j INNER JOIN jb_privacy AS p ON (p.id=j.employer_id) LEFT JOIN jb_emails AS e ON (j.employer_id = e.user_id AND e.is_default = 1 AND p.show_email = 1)LEFT JOIN jb_phone_numbers AS pnum ON (j.employer_id = pnum.user_id AND pnum.is_default = 1 AND p.show_phone=1) LEFT JOIN jb_users AS u ON (j.employer_id=u.id AND p.show_name = 1) LEFT JOIN jb_phone_numbers as fnum ON (j.employer_id = fnum.user_id AND fnum.name='FAX' AND p.show_fax=1) LEFT JOIN jb_addresses AS addr ON (j.employer_id = addr.user_id AND p.show_address = 1) WHERE j.id = 1206: Can't open file: './jlisx_webjobs/jb_phone_numbers.frm' (errno: 24)

histo technologist


Company Name: Northern Tier Gastroenterology Approximate Salary: Not Specified
Location: EYNON, Pennsylvania Country: United States
Industry: Histotechnologist (HTL) Position type: Part Time
Experience level: < 2 years Education level: HTL Certification, HTL(ASCP)

Short Description:
Histo technologist
Long Description:
Immediate opening. Competitive salary
Histosearch     -  -  - Histonet Archives -  -  -  -  
Home | Register | My Account | Employers | Contact Us
All contents © Copyright 2014 Histosearch All rights reserved.