Read an order by reference
Gets an order by its reference number (e.g. store order ref). Use AccountOrders with WITH(OrderReference='...') or, if you have fewer rows, SELECT * FROM Orders WHERE Reference='...' for a faster lookup.
SELECT * FROM AccountOrders WHERE Reference='BIN240202-9666-28133' WITH (OrderReference='BIN240202-9666-28133')
--or for handful rows use below way
--SELECT * FROM Orders WHERE Reference='BIN240202-9666-28133'