SQL Error (1054): Unknown column 'RemainingInventory' in 'where clause'
Obviously RemainingInventory isn't one of the columns in the table, we are doing the Coalesce thing to establish the current stock and giving it the title RemainingInventory.
I've looked at LEFT OUTER JOIN, but again we'd be creating a column title that doesn't actually exist.
Is it not possible to query a table using RemainingInventory as a filter? We're basically trying to only display products whose RemainingInventory > 0.
Thank you for any advice offered.