2008 Apr 09 5:50 AM
hi,
i have created database view
but it showing duplicate entries in it.
how to solve this problem ?
2008 Apr 09 6:28 AM
Hi,
How any tables have you used? Please specify the keys in the Join fields section and it will avoid duplicates.
Reward if useful.
Thanks,
Anita
Make sure that all the primary keys of the data base table should be in your view also.
2008 Apr 09 5:54 AM
Probably you can select the data from the tables based on primary key. Write the joins on the basis of primary keys.
Supriya.
2008 Apr 09 6:13 AM
Make sure that all the primary keys of the data base table should be in your view also.
2008 Apr 09 6:28 AM
Hi,
How any tables have you used? Please specify the keys in the Join fields section and it will avoid duplicates.
Reward if useful.
Thanks,
Anita
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |