Query from results of SQL server query

Question

Not sure how to ask this question, so I ask by giving scenario.

Select ID, CompanyID, Company_name from memberdetails where status in ('A','S');

the query returns say 1000 rows. Now I want to search the table industry_catagory with the result under column CompanyID from above. How can I create this is one single sql statement.

Do you need the results from the first query as well? Or do you just need the CompanyID so you can use it for the second query? — Gavin
– Gavin, Commented Nov 16, 2016 at 19:43
You could join or use a subquery. Use the query provided as a subquery WHERE companyID IN ( Select ID, CompanyID, Company_name from memberdetails where status in ('A','S')) — Wes Palmer
– Wes Palmer, Commented Nov 16, 2016 at 19:45

farmersteve · Accepted Answer · 2016-11-16 21:05:28Z

2

This should be using and more up to date Join syntax:

SELECT CompanyID 
FROM industry_catagory a 
INNER JOIN memberdetails b ON a.CompanyID = b.CompanyID
WHERE b.status in ('A','S')

answered Nov 16, 2016 at 21:05

farmersteve

1214 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2016-11-16 19:54:21Z

1

Use one of the next approaches:

Sub-Query:-

Select CompanyID from industry_catagory 
where CompanyID in (Select CompanyID from memberdetails where status in ('A','S'))

Join:-

Select CompanyID 
from industry_catagory a , memberdetails b
where a.CompanyID = b.CompanyID
and b.status in ('A','S')

edited Nov 16, 2016 at 19:54

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

answered Nov 16, 2016 at 19:49

ahmed abdelqader

3,58220 silver badges38 bronze badges

1 Comment

Juan Carlos Oropeza Over a year ago

Promote the use of explict JOIN sintaxis, Aaron Bertrand wrote a nice article Bad habits to kick : using old-style JOINs about it.

Collectives™ on Stack Overflow

Query from results of SQL server query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related