topic Re: view in Application Development and Automation Discussions

view

Former Member — Wed, 09 Apr 2008 04:50:01 GMT

hi,

i have created database view

but it showing duplicate entries in it.

how to solve this problem ?

Former Member — Wed, 09 Apr 2008 04:54:19 GMT

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 — Wed, 09 Apr 2008 05:13:45 GMT

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

Former Member — Wed, 09 Apr 2008 05:28:23 GMT

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