Below is my query for the above tables.

SELECT a.icode,a.categorycode,a.description,sum(qty),date from items a
inner join sales b on a.icode=b.icode
inner join categories c on a.categorycode=c.code

I have already tried some queries but there is something to add as I can not get the result, I could send the query when required. The table structure is...

Thanks.
What about the query to get the required result.

If a user execute the data between '10-07-2018' and '10-10-2018', the below result is to be appeared.

Thanks, I will check and reply you.

CREATE TABLE [dbo].[Sales](
[Icode] [varchar](255) ,
[Ccode] [varchar](255) ,
[Qty] [int] ,
[Price] [float],
[Date] [datetime]

Insert into [dbo].[sales] (Icode,ccode,qty,price,date)
values
('1','111',10,10,'10/10/2015')
('1','111',5,13,'10/07/2016')
('1','111',3,15,'12/31/2016')

CREATE TABLE [dbo].[Item](

How can I do that as I tried it.

CREATE TABLE [dbo].[Sales](
    [Icode] [nvarchar](255) ,
    [Ccode] [nvarchar](255) ,
    [Qty] [int] ,
    [Price] [float],
    [Date] [datetime]

CREATE TABLE [dbo].[Item](
    [Code] [varchar],
    [Price] [float],
    [Description] [varchar],
    [DateFrom] [datetime],
    [DateTo] [datetime]