Ado Query Inner Join

From: Jeff Howard (jhoward_at_cubiscan.com)
Date: 03/17/05

  • Next message: Bolla Sándor: "String concated from right" 
    Date: Thu, 17 Mar 2005 09:23:04 -0700

    I apologize as this is more of a sql question but I have a Master table and
    a detail table and I have used an inner join sql statement to pull all
    records into an AdoQuery dataset which will give me a result set for each
    master detail record. My question is this, is there a way through a join to
    return the result set from a master detail relationship(all detail records)
    and have those records combined to one record in the result set for each
    unique value from the master table primary key field. In other words rolling
    all details associated with the forgien key into one record combined with
    the data from the master table.

  • Next message: Bolla Sándor: "String concated from right"

    Relevant Pages

    • Re: General Query question
      ... FROM dbo_tblSaaDocument RIGHT JOIN (dbo_tblObligationType INNER JOIN ... I would like to have the master table updated. ... redundancy, which thereby avoids redundancy. ... You store data ONCE, and once only, and then use Queries linking the ...
      (microsoft.public.access.gettingstarted)
    • Re: SQL Statement for limiting the number of detail retrieved in Access 2000?
      ... Hexman wrote: ... INNER JOIN ... How do I limit the number of detail records selected in a Master-Detail set using SQL? ... I want to select all master records for a date, but only the first 3 records for the details. ...
      (microsoft.public.dotnet.languages.vb)
    • Re: General Query question
      ... tables I have in my query. ... FROM dbo_tblSaaDocument RIGHT JOIN (dbo_tblObligationType INNER JOIN ... I would like to have the master table updated. ... You store data ONCE, and once only, and then use Queries linking the ...
      (microsoft.public.access.gettingstarted)
    • Access 2003 INNER JOIN
      ... My Inner Join is not working correctly. ... 911111111, 911111112, TOTAL FOR SUBACCT, NULL, NULL, $200,000.00 ... 911111111, NULL, TOTAL FOR MASTER, NULL, NULL, NULL, NULL, ... lines to compare ...
      (microsoft.public.access.queries)
    • Re: SQL Statement for limiting the number of detail retrieved in Access 2000?
      ... Hexman wrote: ... INNER JOIN ... How do I limit the number of detail records selected in a Master-Detail set using SQL? ... I want to select all master records for a date, but only the first 3 records for the details. ...
      (microsoft.public.dotnet.languages.vb)