Where count of value A is greater than 0, and value B is 0

juspar
Tera Contributor

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