Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
roxcy
Yak Posting Veteran
58 Posts |
Posted - 2006-11-22 : 06:23:29
|
Hi, I am using two tables EmpDetails & SalesDetails.EmpDetails consists of EId,EmpCode,Branch.SalesDetails consists of SrNo,ModelNo,Remarks.On my client End I am using a Dropdown Which consists of SrNo from Table SalesDetails.On selecting SrNo from Dropdown I am trying to display my outPut in Datagrid.I want my output in the Following Format.EmpCode,Branch,ModelNo,Remarks. So i would like to do this using stored procedure . Could someone Help me..plzThanks |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-22 : 06:31:00
|
How do you tie these two tables together?Peter LarssonHelsingborg, Sweden |
|
|
roxcy
Yak Posting Veteran
58 Posts |
Posted - 2006-11-22 : 06:44:35
|
Will using innerjoin be the best possible solution? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-22 : 06:53:24
|
Maybe. But we still don't know how to tell which records/rows for SalesDetails table to connect to which records/rows in EmpDetails table.Peter LarssonHelsingborg, Sweden |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-22 : 12:05:04
|
quote: Originally posted by roxcy Will using innerjoin be the best possible solution?
Yes. Use join. What is your problem? Did you try using joins?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|