Ignore this one. I forgot to have join key on for the two table selection.
8/5/2002 11:21:14 AM, Vernon Wu <vernonw@gatewaytech.com> wrote:
>
>I experience a situation for the same select statement having duplicate data returned using jdbc of pgsql, while only
one
>single set date returned on the pqsl window. I need to add the "distinct" in the select statement to have a single
set
>data returned.
>
>Is the advicable practise to have the 'distinct' key word on every selection statement?
>
>Thanks,
>
>Vernon
>
>
>