• You haven't provided enough information for anyone to provide an accurate answer.

    What do you want the view to provide? A union of the results from the tables or a Join of the results of the tables?

    What are the relationships between the tables that would allow you to join them together? The only foreign key you have defined is:

    ALTER TABLE [dbo].[College_CutoffMaster] WITH NOCHECK ADD CONSTRAINT [FK_College_CutoffMaster_College_CutoffMaster] FOREIGN KEY([CutoffId])

    REFERENCES [dbo].[College_CutoffMaster] ([CutoffId])

    and I don't even know how that would work as you have column referencing itself so I don't even know how that would work since once you have cutOffID 1 in the database it can only reference itself since you can't insert another CutOffID 1 because it is also the Primary Key.

    Since I'm forced to guess I assume that you would JOIN college_cutoffmaster to college_Maharashtra_ArchitectureCutoffmaster on CutoffID, but I don't know that. I'm not sure how you'd join to the third table.