Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

view

Former Member
0 Kudos

hi,

i have created database view

but it showing duplicate entries in it.

how to solve this problem ?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

3 REPLIES 3

Former Member
0 Kudos

Probably you can select the data from the tables based on primary key. Write the joins on the basis of primary keys.

Supriya.

Former Member
0 Kudos

Make sure that all the primary keys of the data base table should be in your view also.

Former Member
0 Kudos

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