https://community.developer.cybersource.com/t5/The-Watercooler/Need-help-with-Join-and-More/m-p/79947#M292 <P class="">I am in and out of SQL and I am busting the rust once again.</P><P class="">I have 2 tables (Order and Ship) that are very similar and have a lot of the same info.</P><P class="">Order's rows are created on order creation. Ship's are created when orders are completed.</P><P class="">Ship's has an important column that has tracking information on it.</P><P class="">Therefore, Order has 100% all of the Order ID's. Ship only has some Order ID's as Order ID's are completed.</P><P class="">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.</P><P class="">What is the best way to do this?</P> Fri, 19 Nov 2021 11:20:31 GMT ColinGrandhomme 2021-11-19T11:20:31Z https://community.developer.cybersource.com/t5/The-Watercooler/Need-help-with-Join-and-More/m-p/79947#M292 <P class="">I am in and out of SQL and I am busting the rust once again.</P><P class="">I have 2 tables (Order and Ship) that are very similar and have a lot of the same info.</P><P class="">Order's rows are created on order creation. Ship's are created when orders are completed.</P><P class="">Ship's has an important column that has tracking information on it.</P><P class="">Therefore, Order has 100% all of the Order ID's. Ship only has some Order ID's as Order ID's are completed.</P><P class="">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.</P><P class="">What is the best way to do this?</P> Fri, 19 Nov 2021 11:20:31 GMT https://community.developer.cybersource.com/t5/The-Watercooler/Need-help-with-Join-and-More/m-p/79947#M292 ColinGrandhomme 2021-11-19T11:20:31Z