SQL QUERY从两个表中获取值 [英] SQL QUERY GETTING VALUE FROM TWO TABLE

问题描述

SELECT  distinct ejp.JOB_POST_CODE,COMPANY_CODE,JOB_TITLE,JOB_DESCRIPTION
from EMPLOYER_JOB_POST ejp,
(SELECT COUNT(USER_CODE) count_user FROM EMPLOYER_APPLY_JOB eaj
where eaj.COMPANY_CODE='CC0000001'
GROUP BY JOB_POST_CODE) applied_job
where ejp.COMPANY_CODE='CC0000001' order by ejp.JOB_TITLE asc

这是我的查询它有两个表一个是员工帖子工作的东西具有作业ID和其他表的作业标题和作业描述具有使用jb id的用户代码。包含no的数据。用户申请特定工作。

我创建了proc计算NO。用户申请特别工作与工作细节。



请帮助我..............



谢谢你提前

this is my query its have two table one is employe post job which containg job title and job description with job id and other table have user code with jb id . contain the data of no. of user applied for particular job.
i m creating proc with CALCULATE THE NO. OF USER APPLIED FOR PARTICULAR JOB WITH JOB DETAILS.

PLEASE HELP ME..............

THANK YOU IN ADVANCE

推荐答案

试试吧......

Hi, try this...

SELECT distinct ejp.JOB_POST_CODE,ejp.COMPANY_CODE,ejp.JOB_TITLE,ejpJOB_DESCRIPTION,Eaj.count_user
from EMPLOYER_JOB_POST ejp
Left join
(
SELECT JOB_POST_CODE,COUNT(USER_CODE) count_user FROM EMPLOYER_APPLY_JOB
GROUP BY JOB_POST_CODE
)eaj
On ejp.JOB_POST_CODE=eaj.JOB_POST_CODE
where ejp.COMPANY_CODE='CC0000001'
order by ejp.JOB_TITLE asc

自我没有数据我无法验证。试一试。

Since I dont have data I cant verify. Just give it a try.

SELECT distinct ejp.JOB_POST_CODE,COMPANY_CODE,JOB_TITLE,JOB_DESCRIPTION
from EMPLOYER_JOB_POST ejp inner join
(SELECT COUNT(USER_CODE) count_user FROM EMPLOYER_APPLY_JOB eaj
GROUP BY JOB_POST_CODE) applied_job on applied_job.COMPANY_CODE= ejp.COMPANY_CODE
where ejp.COMPANY_CODE='CC0000001' order by ejp.JOB_TITLE asc

SELECT  distinct COUNT(USER_CODE) count_user,ejp.JOB_POST_CODE,COMPANY_CODE,JOB_TITLE,JOB_DESCRIPTION
from EMPLOYER_JOB_POST ejp inner join EMPLOYER_APPLY_JOB eaj on 
eaj.COMPANY_CODE=eaj.COMPANY_CODE where eaj.COMPANY_CODE='CC0000001'
group by ejp.JOB_POST_CODE,COMPANY_CODE,JOB_TITLE,JOB_DESCRIPTION

这篇关于SQL QUERY从两个表中获取值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！