Unmatched records from 2 table into 1 table???

[RookieDBO]

I have two tables that I want to create a query from. How do you create a query that would show both unmatch records into one table regardless if it's null record? In another word a "Full Join". Is this possible in ACCESS??? For example, one table contains "booked_qty" products and the other table is "shipped_qty" products. In reality products were booked but necessarily were shipped and vice versa.

Thanks,
RookieDBO

 

[tempclerk]

In query design view, double-click the line joining the two tables and select show all records from table 1 and only matching records from table 2.

 

[tempclerk]

(That makes it a LEFT JOIN in SQL view)