I'm using suiteql to query

InventoryBalance

for on-hand inventory, but it's only returning items that are greater than zero on-hand. Is there any to force that to return the zero's as well?

Join the item table?

ya im going down the route now of doing some subqueries. was hoping there was some magic i didnt know about