Multi tool use

Clash Royale CLAN TAG

Stored Procedure issue which states Procedure: [dbo].[GetInfo] contains an unresolved reference to an object

Guys I really need your help. So, the problem is in Visual Studio I am trying to create stored procedue with inner join of two tables: КатегорииЗатрат (in English means Category) and Расходы (in English means Expenses) in order to make sure that I could show name of Category instead of its id. However, I encountered with error as Procedure: [dbo].[GetInfo] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[КатегорииЗатрат].[c]::[КатегорииЗатратId] or [dbo].[Расходы].[c]::[КатегорииЗатратId]. The code that I am using:

Procedure: [dbo].[GetInfo] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[КатегорииЗатрат].[c]::[КатегорииЗатратId] or [dbo].[Расходы].[c]::[КатегорииЗатратId]

Create PROCEDURE [dbo].[GetInfo]

AS
Begin
SELECT
[Период],
[Стоимость],
[КатегорииЗатратId],
[Комментарий]
FROM [dbo].[Расходы] as с inner join [dbo].[КатегорииЗатрат] as cat on c.КатегорииЗатратId=cat.Id
End


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.