I Want To Make a Query in Which I need
1)Date And Quantity of Item Having ItemCode WH-100 From inventory Transfer
2) Quantity of Component item Whose item Code is 'WH-100' from production order But Here Date Should be From Receipt From Production
Please Help Me to Solve this Problem...
And Also I want to write this query in ms SQL server 2008