elisabeth
08-12-03, 08:39
| Hi, can anyone think of how to get round this. I am using MS Excel Query on my Oracle database. I want to make a spreadsheet showing account number, customer 1, customer 2, customer 3. There is an accounts table, an accounts_links table which links the customers to the accounts and a customers table. On the accounts_links table there is one row for each customer on an account with a "holder number" to say if it is customer 1, 2 or 3. At the moment I am only bringing back accounts where there are 3 customers. Some accounts will only have 1 or 2 customers. I thought to bring in the accounts_links and customers tables in three times now it is just multiplying all the rows together! Can anyone think of a way round this to run it in one sql, I don't want to have to use excel functions. Thanks, Beth |