Table Relatiotionships and data exchange

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables that have data obtained from a mainframe application on a daily basis. One is Loans Approved and the other table is Loans Funded. The Loan number would be the common element in both tables

I need to be able to show only those loans from the loans approved table that are not in the loans funded table

How can I accomlish this by a query or what?

Any help would be appreciated.
 
Yes. There is an Unmatched Query wizard to achieve this for you.

Essentially, it gives you an outer join where [Loans Funded].[LoanID] is
null.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Steve said:
I have 2 tables that have data obtained from a mainframe application on a
Click to expand...
daily basis. One is Loans Approved and the other table is Loans Funded. The
Loan number would be the common element in both tables.
I need to be able to show only those loans from the loans approved table
Click to expand...
that are not in the loans funded table.
 
Back
Top