I’d like to do a GI to show quantity available of stock items that is filtered by a vendor ID who has a cross-reference number for that stock item. I’ve identified the data lives in these tables but am not having luck getting the results: I either get 30k plus rows where it shows the same stock items many times over or errors that indicate my joins are off.
I’m not an SQL expert unfortunately and hoping this is something that can actually be accomplished with a GI instead of custom dev.
See below for my tables, joins, and filter.
