>Nick,
>
>Not sure of one more thing:
>
>
>The Inventory table has RecordId and Description fields.
>
>The Order_Items has a foreign key into Inventory. Its a One-To-Many,
>Order_Items.ItemId -> Inventory.RecordId.
>

So, you want the description from Inventory table to be in your Order_Items view, right?
According to this it should be:

CREATE SQL VIEW v_items AS ;
SELECT ORDER_ITEMS.* , Inventory.Description ;
FROM ORDER_ITEMS ;
INNER JOIN inventory ;
ON Order_Items.ItemId = Inventory.RecordId;
WHERE ORDER_ITEMS.ParentId = ?cCustomerId