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 |
|
fakhre
Starting Member
2 Posts |
 Posted - 2009-11-27 : 04:53:54
|
| dear all, i want to get the records in this way, all the unique records from table a and details of each record from table b. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-11-27 : 04:56:14
|
| can u post some sample data and required outputu can use row_number function to get unique records........... |
 |
|
|
fakhre
Starting Member
2 Posts |
Posted - 2009-11-27 : 05:15:23
|
| table a is something look like this.. random no. pid color 1 NULL 1234AF FUCHSIA2 d1zspez4yrz3jbvizmlasm55 1234AF GOLD3 ns2qew45iw4slm55iwetfxiu 1234AF FUCHSIA4 ns2qew45iw4slm55iwetfxiu 1268 BLACK5 ns2qew45iw4slm55iwetfxiu 1375 BLACK7 ns2qew45iw4slm55iwetfxiu 1268 BLACK8 ns2qew45iw4slm55iwetfxiu 502968 BLACK10 ns2qew45iw4slm55iwetfxiu 502968 BLACK11 ns2qew45iw4slm55iwetfxiu 502968 BLACK13 ns2qew45iw4slm55iwetfxiu 502968 BLACK6 ns2qew45iw4slm55iwetfxiu 1409 BLACK9 ns2qew45iw4slm55iwetfxiu 502968 BLACK12 ns2qew45iw4slm55iwetfxiu 502968 BLACKi want to have the records (unique ) from this table.. under the pid and want to get its details as pid from details tablei hope u understand .. |
|
|
|
|
|
|
want to get record in this way...