Ok, so this request was a weirder one. I need to create a query from a flat file that I got from our contracting dept.
I have a table that table that has Business Name, Tax-ID, Contracts...
We collect a percentage of collections through our contracts.
So I want to print a list of business names, and then the CONTRACT Name for any business that has no submissions. It's easy to print the business name and then the values, but I just need the contract name ONLY if the submission is Null. Any help is appreciated.