I think this should be easy, but I just can figure it out. I want to make a SQL View that has a [Part No] and the last activity date. The activity date should come from either the order table or the shipping table. I want the SQL to be able to return my whole part master table with the last ACTIVITY date.

Table 1 PartMaster
Fields: [Part No]

Table 2 Orders
Fields: [PART NO], [ORD DATE]

Table 3 Shipping
Fields [PART NO], [SHIP DATE]

Now I want to end up with a view that has

[PART NO], [LAST ACTIVITY DATE]