I am in and out of SQL and I am busting the rust once again.
I have 2 tables (Order and Ship) that are very similar and have a lot of the same info.
Order's rows are created on order creation. Ship's are created when orders are completed.
Ship's has an important column that has tracking information on it.
Therefore, Order has 100% all of the Order ID's. Ship only has some Order ID's as Order ID's are completed.
The problem is that I want to pull up all of Order ID's from Order's Table, but also fill in any of the Order ID's row's with tracking if it is available.
What is the best way to do this?
