So why not just just select the StockId from the stock table? That will return all wither or not they have ever been ordered