Advanced Subqueries - query fields
When building a report and using the Advanced sub query function to join two Views is it "required", "recommended" or "best practice" that the fields sued for Master Query and Sub Query be numeric versus character?
I struggled to get this to work using fields the DB team created that were defined as CHAR in the database for the application. Once I had them create new columns defined as bigint with the same values I got much better and more predictable results.
Looking for guidance for future DB designs