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 |
|
brr_hyd
Starting Member
4 Posts |
 Posted - 2010-01-22 : 02:31:10
|
| hi all,Iam Ram. iam new to sql server. iwant a query plz help. here my requirement is, i have 3 tables table a table b table c---------------------------------------------------------------------StockDesc|stockid| |stockid| FundCode|citiCode---------------------------------------------------------------------ABC s1 s2 s1 A1DEF s3 s4 s4 A2GHI s5 s6 s6 A3 so here 1st table stock ids, and 2nd table stock ids contain in 3rd table fundcode(fundcode contain table a, table b stockids) so here i have to catch, 3rd table citicode based on 1st table stockid, and 2nd table stockid, with compare 3rd table fundcode.My out shouldbe like this.---------------------------------------------------------------------StockDesc citiCode---------------------------------------------------------------------ABC A1DEF A2GHI A3plz help how to write query for this. i need it urgently. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-22 : 02:47:43
|
| "i need it urgently"Are you paying for a solution then? Or just expecting good people to work urgently for you for free?Anyway, if its urgent I'm presumably too late, so I will move on ... |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
|
|
|
Need Query Urgently..