Continuation of practical Aspcet of Joining Data.

Inner join does not have arrow shape on either side of the join . When you change the line will change also . Like It was mentioned in the last class running this query on the existing example will only give us products that have been order . To get products that have not been order , we will need an left outer join. To do this I will go to click on left outer join on design view, right click and go to join properties .