Get headers where there are no associated details/lines


  • I have a SalesOrderHeader Table and a SalesOrderDetail Table.

    They are linked by a SalesOrderID.  Each SalesOrderHeader may have multiple SalesOrderDetails.

    I want to find all SalesOrderHeaders that do NOT have any SalesOrderDetails lines.

    Can I do a join where the SalesOrderID's are not equal?

    Any Suggestions?

    Tuesday, October 29, 2013 9:32 PM


All replies