I am trying to join two databases in an SQL query. Database A has a table with a 5 digit client number and another table with a 5 digit matter number. The other database, B, has a table with one field ...

Multiple Detail Records - 4 in this case. (linked to the header record) Multiple Inventory Records - again, 4 - (each detail record points to one specific inventory record, but the inventory may be ...