How to compare two tables

See more:

SQL

Consider the below two tables.
TABLE A

Order  invoice  date       quantity  cust_code
111     45     20/08/2017   9          abc
112     32     21/08/2017   4          abc
113     42     22/08/2017   5          abc
114     49     20/08/2017   5          abc

TABLE B

Order   date       quantity
 111     20/08/2017   3
 111     20/08/2017   6
 113     22/08/2017   5
 49      20/08/2017   5
 112     21/08/2017   4

Now in table B the values in Order column can either be the order column from table A or the Invoice from table A. I want to join the tables in such a way that i add the missing columns in table B from table A.

Expected result

Order   date       quantity  Invoice
 111     20/08/2017   3       45
 111     20/08/2017   6       45
 113     22/08/2017   5       42
 49      20/08/2017   5       49
 112     21/08/2017   4       32

What I have tried:

select * 
from Table B  d2
left join Table A d1 on d2.Invoice =d1.order 

This only matches the order column. So in expect result table Row 4, in invoice column it will say null, i do not want that. if the order column does not match then i want it to check the invoice column.