Join inventory item table multiple times to a view

Is the LeftJoin / InnerJoin purposeful? I believe it will exclude any rows that don’t have a match in the second join.

This post states the following:

You also need to override the parameters that will be used for the comparison so the system can bound them.

I think you need something like:

public class InventoryItemTwo : InventoryItem
{
    public new class inventoryID : IBqlField{}
    public new class inventoryCD : IBqlField{}
}

And possibly a separate first type as well:

public class InventoryItemOne : InventoryItem
{
    public new class inventoryID : IBqlField{}
    public new class inventoryCD : IBqlField{}
}

i had started out with left join on both and it still did it. I tried to change it to inner join to see if that would fix it but it did not.

​@darylbowman i added that in there and i got several errors. first it gave me errors saying it needs to be abstract. so i added that. then it gave me the below error on the view name. i changed the “inventoryID” to “InventoryID” but when i build it i get an error in the screen. when i tried it with just inventoryitemtwo, i got it to load but it was still duplicating. when i did it with one and two it also didnt work.

​@darylbowman that did it. Thank you very much!