Yes, I have twelve files embedded. And, yes, once again I'm having trouble with very simple T-SQL syntax.
A lot of the files that I have attached are for background purposes. What I'm having trouble with, specifically, is shown within the SQL file labeled "Combined_0100010453 and 266267.sql".
Please don't ask me why. But, per the results shown from its corresponding Excel file ("Combined_0100010453 and 266267.xlsx"), I do not want the two rows that are appearing for customer 266267.
Other than simply saying "where "RM20101.CUSTNMBR <> '266267", please let me know how I can use the criteria that I have specified in this query, while still allowing for these two rows to not be displayed in the results.
I'm thinking that there must be something that I can place in that subquery "(select APFRDCNM from RM20201)". But, I'm not smart enough to figure out what.
Again, please let me know how to keep the rows for 0100010453, while not keeping the rows for 266267.
By the way, you will see the amounts for these two rows within the .xlsx file entitled "RM20201_266267" in cells O34 and O35.
Thank you! Much appreciated!