If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating two joins then joining the result

Started by Newbie1230, 11 May 2023 03:04:31 PM

Previous topic - Next topic

Newbie1230

I could really use some help! I have been thrown into this role with zero guidance and know basic reporting writing. Basically what I need to do is pull a list of customers that have loans but no deposits. I also want to make sure that if there are any secondary customers that are associated with a loan and they have a deposit account, we exclude them from the list.

So far this is what I have.

Create a query using the primary customer table and create a query using the secondary customer table and join by the tax ID.

Create a query using the demand deposit table and the loans table and join using customer name.

Join the first query with the second query? Then apply any filters? This is kind of where I am stuck and don't know if I'm even going about this the right way.

I really appreciate any help!