none
Get headers where there are no associated details/lines

    Question

  • 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

Answers

All replies