Problem : Retrive Data with ref table

[ahmed17]

Tables :

Create Table Catgerories (
CatgId int PRIMARY KEY,
Catgname nvarchar(50)
)

Create Table StudentInfo(
stId int PRIMARY KEY,
Stname nvarchar(50),
CatgId int  REFERENCES Catgerories (CatgId)
)