EORROR : Near Keyword SELECT on 6 line

Question

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[FlowClientGetCatWeb] 
(@ID_Izmerit Integer, @ID_User Integer, @APP bit) 
AS 
SELECT Name, (CAST(ID_ListGroupParIzm AS nvarchar(10))+'_'+CAST(Point AS nvarchar(10))) AS GroupPoint 
FROM 
SELECT ID_ListGroupParIzm, Name, Point 
FROM FlowClientGetCat(@ID_Izmerit,@ID_User,@APP)

why error ? and how to fix :-/

Answer 1

Enclose the nested query into parenthesis:

ALTER PROCEDURE [dbo].[FlowClientGetCatWeb] 
(@ID_Izmerit Integer, @ID_User Integer, @APP bit) 
AS 
SELECT  Name, (CAST(ID_ListGroupParIzm AS nvarchar(10))+'_'+CAST(Point AS nvarchar(10))) AS GroupPoint 
FROM    (
        SELECT  ID_ListGroupParIzm, Name, Point 
        FROM    FlowClientGetCat(@ID_Izmerit,@ID_User,@APP)
        ) q