• 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)