If I have two subsidiaries, A and B, how do I search for all items that belong to only A, and not include items that belong to both?

select * FROM item WHERE subsidiary='A'

Not sure if suiteql is on the table here

nope, no suiteQL, but asking the question here was able to jog my Friday brain into some sort of solution: No Subsidiary Criteria, Group on Item Name, and Summary Criteria where Count(Subsidiary) = 1 AND Min(Subsidiary) = <Name of Subsidiary> This may be an suboptimal way of doing it though 😅

curious why would one exclude SuiteQL as an option, here on the suitescript channel?

My assumption is just lack of familiarity