how to distinct one column when using inner join
Posted
by
kusha
on Stack Overflow
See other posts from Stack Overflow
or by kusha
Published on 2012-07-04T07:30:36Z
Indexed on
2012/07/04
21:16 UTC
Read the original article
Hit count: 155
i am using two table postjob and job location want to distinct jobtitle
The query is:
select postjob.jobtitle,
postjob.industry,
postjob.companyname,
postjob.jobdescription,
postjob.postid,
postjob.PostingDate,
Job_Location.Location,
Job_Location.PostigID
from postjob
inner join Job_Location
on postjob.postid = Job_Location.PostigID
Where postjob.industry=' Marketing, Advertising'
output of this query http://www.justlocaldial.com/Industry_search.aspx?ind=Marketing,%20Advertising
© Stack Overflow or respective owner
