How to retrieve multiple data in a column of a table using a query?

Question

I have 2 tables named as master and kpi.
Master table has following columns

no, name, dtStart, dtEnd, status, user and dtCreate

kpi table has following columns

no and kpName

"no" in kpi table refers "no" in master table

What i expect to do is, when I select a name from the dropdownlist relevant details in both tables should be displayed.
One name has unique "no". Also "no" can have multiple kpNames.
Please help me.

Please tell us the relationship between these two tables, ideally along with some sample data. — Tim Biegeleisen
– Tim Biegeleisen, Commented Oct 26, 2016 at 10:01
Add some sample table data, and the expected result. (As well formatted text.) — jarlh
– jarlh, Commented Oct 26, 2016 at 10:02

Jaydip Jadhav · Accepted Answer · 2016-10-26 10:19:36Z

2

try this:

SELECT a.[no], a.name, a.dtStart, a.dtEnd, a.[status], a.[user] , a.dtCreate 
From masterTable  a 
Inner JOIN kpiTable b ON a.[no] = b.[no]
Where b.Name = 'dropDownSelectedValueName'

edited Oct 26, 2016 at 10:19

Jaydip Jadhav

12.3k6 gold badges26 silver badges41 bronze badges

answered Oct 26, 2016 at 10:06

James

7276 silver badges10 bronze badges

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

1 Comment

James Over a year ago

as mentioned, u can create a stored Procedure and call it on every time drop down selection change, it has its own advantages.

marc_s · Accepted Answer · 2016-12-17 22:48:43Z

2

You have to make a stored procedure and then join both tables. Here is sample

create proc Details
begin
@Name char(50)
select * from Master m join kpi n ON
 m.no==n.no where Name== @Name
end

edited Dec 17, 2016 at 22:48

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 26, 2016 at 10:09

Shah Hassan

1557 bronze badges

Comments

Zeina · Accepted Answer · 2016-10-26 10:58:34Z

1

SELECT table1.[no], table1.name, table1.dtStart, table1.dtEnd, 
table1.[status], table1.[user] , table1.dtCreate ,table2.kpName 
FROM masterTable [table1] 
INNER JOIN kpiTable [table2] 
ON table1.[no] = table2.[no] 
WHERE table2.Name = 'Your Selected value'

edited Oct 26, 2016 at 10:58

Zeina

1,5912 gold badges25 silver badges34 bronze badges

answered Oct 26, 2016 at 10:32

Mansoor

4,1921 gold badge19 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to retrieve multiple data in a column of a table using a query?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related