error, more than one row retrieved, sql is [select c.id id,
c.title c_title,
c.job_type job_type,
c.location_street location_street,
c.location_city location_city,
c.location_county location_county,
c.location_state location_state,
c.location_zip location_zip,
c.comp_code comp_code,
c.comp_rate comp_rate,
c.dur_code dur_code,
c.dur_time dur_time,
c.degree_id degree_id,
c.introduction introduction,
c.qualification qualification,
c.responsibility responsibility,
c.additional_info additional_info,
c.district district,
c.work_schedule work_schedule,
p.job_status job_status,
p.id post_id,
p.post_start post_start,
p.post_end post_end,
p.published_id published_id,
t.first_name first_name,
t.last_name last_name,
t.title t_title,
t.contact_pref contact_pref,
t.phone_number phone_number,
t.fax_number fax_number,
t.email_address email_address,
t.smail_company smail_company,
t.smail_street smail_street,
t.smail_street2 smail_street2,
t.smail_city smail_city,
t.smail_state smail_state,
t.smail_zip smail_zip,
t.url url
FROM jbs.job_class c
INNER JOIN jbs.posting p ON c.id = p.job_desc_id
INNER JOIN jbs.contact t ON c.contact_id = t.id
and c.id = 1122
and p.job_status = 'O']
|
|
|
|
|
Job Title:
|
( County), |
|
Position Available:
|
|
|
Application Deadline:
|
|
|
Published Id:
|
|
|
|