Skip to Content
0
Former Member
Jul 28, 2016 at 01:53 PM

SQL Query

96 Views

Dear All

Any help will be appreciated. I have made a query:

SELECT T1.[ItemCode] AS 'Item No.', T1.[ItemName] AS 'Item Description', T1.[OnHand] AS 'In Stock', T1.[InvntryUom] AS 'Stock UoM', T0.[UgpName] AS 'UoM Group Name' FROM [dbo].[OUGP] T0 INNER JOIN [dbo].[OITM] T1 ON T1.[UgpEntry] = T0.[UgpEntry]

Can someone amend this for me, so I may be able to:-

1. User should be asked to enter the range of the Item code

2. Inactive products should not show up.

Thanks in advance.