Get accounts from SummaryTable to every record in DetailTable

[XP]

Assuming:

SummaryTable contains summary info in which the value of several items have
been added together for each transaction. DetailTable contains detailed info
in which a separate record is included for every item composing each
transaction.

SummaryTable, with many fewer rows, includes an account number. The TranID
is the primary key in both tables and relates the transactions. I need a
query that pulls detailed information from DetailTable, but includes an
account number for every item in the query from SummaryTable. For now at
least, I just want all records from the DetailTable.

Can someone please post generic example SQL how I would do this?

Thanks much in advance.

 

[Marshall Barton]

Assuming:

SummaryTable contains summary info in which the value of several items have
been added together for each transaction. DetailTable contains detailed info
in which a separate record is included for every item composing each
transaction.

SummaryTable, with many fewer rows, includes an account number. The TranID
is the primary key in both tables and relates the transactions. I need a
query that pulls detailed information from DetailTable, but includes an
account number for every item in the query from SummaryTable. For now at
least, I just want all records from the DetailTable.

If a transaction can have multiple details, then TranID can
not be the detail table's primary key. Maybe you meant that
it is part of the PK??

Regardless, try joining the two table on the TranID field

SELECT S.TranID, S.TranTotal, D.AccountNum, D.Amount
FROM SummaryTable As S INNER JOIN DetailTable As D
ON S.TranID = D.TranID