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 |
|
viguro
Starting Member
12 Posts |
 Posted - 2010-04-14 : 09:46:16
|
| Hello everyone,I have two tables (ledger and PO) that I want to join in a view for a report. their PKs are different and there is only a few colunms I can Join ON. but when ran, I still get duplicates rows.I tried left, right, full joins, no change.I also tried distinct but it says: text, ntext,... cannot be selected as distinct.Any ideas on how to get rid of these duplicates?thank you for you time.Vig. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-04-14 : 09:49:06
|
| Posting some sample data & expected output will be of much help for anyone to understand your problem.PBUH |
 |
|
|
|
|
|
Need Help with duplicates