所以为你的JOIN条件添加一个标准：

So add a criteria to your JOIN condition:

SELECT b.[Order], b.[Date],  b.Quantity, a.Invoice
FROM TableB  b
LEFT JOIN TableA a ON b.[Order] = a.[order] OR b.[Order] = a.Invoice