Skip to Content
0
Former Member
Mar 01, 2009 at 11:28 PM

Help with SQL Code - Production Order with Manual Issue Method

47 Views

Hi,

I need some assistance here.

I need to retrieve Production Order which has component's issue method = 'M'.

Eg:

Production Order #50001 has 4 components.

Component A, issue method = 'M'

Component B, issue method = 'B'

Component C, issue method = 'B'

Component D, issue method = 'M'

Production Order #50002 has 2 components.

Component B, issue method = 'B'

Component C, issue method = 'B'

When I run the query, I want to display the Production #50001 componenets simply because in this Production Order, it contains components with issued method 'M'. However, Production #50002 will not be displayed because no components are with issued method = M.

Appreicate any help in advance.