How to make distinct like this

From: Thomas Seban (tse_at_relate.de)
Date: 01/21/04 

Date: Wed, 21 Jan 2004 09:24:34 +0100

Hallo,

i have a query between two tables. First table has master records, the
second has detail record. Now i want all data from master table, but only
the first or the last record from detail. Getting all data from detail table
is no problem.

Is there a solution with SQL?

Best Regards
Thomas Seban

Relevant Pages

  • Re: Count vs Distinct
    ... It does return all master records that have more than 1 details record. ... "Ivan Debono" wrote: ... I need to create a query based on a master-details tables scenario, ...
    (microsoft.public.access.queries)
  • Re: Count vs Distinct
    ... That gives me all master records that have more than 1 details record. ... can I expand the statement to get all those master records that have all ... I need to create a query based on a master-details tables scenario, ...
    (microsoft.public.access.queries)
  • Master Detail question
    ... How can I display only those master records that have detail records using ... either table or query? ...
    (borland.public.delphi.database.ado)