Query A
SELECT
e.es_id,
e.site_id,
e.bu_id,
e.comp_code,
e.submit_time,
e.status,
e.currency,
j.lt_id
FROM
dbo.exp_sheet e(nolock)
INNER JOIN dbo.work w(nolock) on e.work_id = w.work_id
INNER JOIN dbo.job_post j(nolock) on w.job_post_id = j.job_post_id
WHERE
w.work_type = 1 AND e.status IN (0,1,5,31,97)
Query B
SELECT
e.es_id,
e.site_id,
e.bu_id,
e.comp_code,
e.submit_time,
e.status,
e.currency,
j.lt_id
FROM
dbo.exp_sheet e(nolock) cross JOIN dbo.work w(nolock) cross JOIN dbo.job_post j(nolock)
WHERE
e.work_id = w.work_id
AND w.work_type = 1
AND w.job_post_id = j.job_post_id
AND e.status IN (0,1,5,31,97)
Query C
SELECT
e.es_id,
e.site_id,
e.bu_id,
e.comp_code,
e.submit_time,
e.status,
e.currency,
j.lt_id
FROM
dbo.exp_sheet e(nolock),
dbo.work w(nolock),
dbo.job_post j(nolock)
WHERE
e.work_id = w.work_id
AND w.work_type = 1
AND w.job_post_id = j.job_post_id
AND e.status IN (0,1,5,31,97)