I have 2 tables connected together
Table 1 include all store deals codes
Table 2 include all orders generated
2 tables is connected together through column Deal_Code_id
in my analysis phase i can only see deal codes that have orders generated in table 2. but i can’t see all deals created in Table 1 if there is no orders in Table 2… How can i display all Deal codes even there is no orders to these deals