Results 1 to 2 of 2

Thread: Difficult SQL

  1. #1
    Join Date
    Jul 2003
    Location
    England
    Posts
    26

    Unanswered: Difficult SQL

    Hello,

    Please can anyone help?

    I have got two tables, accounts and account customers.

    The accounts table has more than one row for each account, identified by the account number and the sub account.

    Each customer should be linked to all of the sub accounts for their account (in the account customers table).

    I have found some accounts where one customer might be linked to all the sub accounts but the 2nd customer on the account is only linked to one of the sub accounts. This is wrong & needs to be corrected.

    Please can anyone advise how I go about selecting all of the problem accounts.

    To start with I grouped all the existing links together, I then need to somehow check each account against this main list.

    Please can you advise.

    Thanks,
    Beth
    Beth

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink

    Beth, describe the tables and give sample data.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •