V
VE Kiwi
Hi - This has probably been answered a plenty of times before, but I can't
seem to track down a thread to answer it :-(
I have a table containing customers who may have a Branch Cash Account
assigned to them i.e. they are deemed too small to create a specific Customer
account, plus the 'full' Customer accounts (approx. 66K records). I have a
second table with the list of Branch Cash Accounts (about 80 records), plus a
Cah Account indicator (a 'X'). My query returns all accounts that are Cash
Accounts (approx. 39K records), but I want to be able to also run the (a)
query to return the 27K odd records that are 'proper' customers.
Apologies if the question is a 'brain dead' one, but I'm stumped...
Cheers!
seem to track down a thread to answer it :-(
I have a table containing customers who may have a Branch Cash Account
assigned to them i.e. they are deemed too small to create a specific Customer
account, plus the 'full' Customer accounts (approx. 66K records). I have a
second table with the list of Branch Cash Accounts (about 80 records), plus a
Cah Account indicator (a 'X'). My query returns all accounts that are Cash
Accounts (approx. 39K records), but I want to be able to also run the (a)
query to return the 27K odd records that are 'proper' customers.
Apologies if the question is a 'brain dead' one, but I'm stumped...
Cheers!