Where count of value A is greater than 0, and value B is 0
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-08-2024 08:52 AM
Hey all.
I'm new to this and trying to wrap my brain around SN relationships. I am looking for a way to query the list of users who have computer(s) where the Model is A, and do NOT have computer(s) where the Model is B.
It seems like I want to be do some kind of DISTINCT COUNT on the Asset related list to the sys_user table. But I've run out of ideas on how to even start. Hopefully this is a known stumbling block for newbies, and there a training resource you can point me at.
Thanks!
Justin
0 REPLIES 0