Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to join multiple tables (SQL) to find the difference between an order and shipped quantities? RE: How to join multiple tables (SQL) to find the difference between an order and shipped quantities?

  • The naming conventions are poor.

    The order connects to the shipment via the PO - PO in shipping is the OrderRef1 in the ORDER table