Inner join 2 tables one to many 2 where clauses
- by user2892350
I'm a relative rookie at this,so please bear with me...
I have 2 tables: OrderDetail and OrderMaster...both have a column named SalesOrder.
OrderDetail table has multiple rows per unique SalesOrder.
OrderMaster table has one row per unique SalesOrder.
OrderDetail has a column named LineType.
OrderMaster has a column named OrderStatus.
I want…
