04-09-2008 5:50 AM
hi,
i have created database view
but it showing duplicate entries in it.
how to solve this problem ?
04-09-2008 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
04-09-2008 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.
04-09-2008 6:13 AM
Make sure that all the primary keys of the data base table should be in your view also.
04-09-2008 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