Re: duplicate information

From: Gleb Shulman <glebsky_at_gmx.net>
Date: 11 Oct 2001 20:19:25 -0700
Message-ID: <8ff19c60.0110111919.7a9fa7e5_at_posting.google.com>

sumera.shaozab_at_lmco.com (SAS) wrote in message news:<a741872d.0110101012.79c7103e_at_posting.google.com>...
> [snip]
> How can I approach this problem so that for each record returned I
> ignore the duplicate information and get take the unique informaton
> for that A.R_id and A.F_id?
> [snip]

You should use group functions for fields with multiple values and group by statement.

Regars Received on Fri Oct 12 2001 - 05:19:25 CEST

This message: [ Message body ]
Next message: Frank van Bortel: "Re: Trying to change data in a staging table."
Previous message: Sybrand Bakker: "Re: Servicename & SID"
In reply to: SAS: "duplicate information"
In reply to SAS: "duplicate information"
Next in thread: Frank van Bortel: "Re: Trying to change data in a staging table."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message