Cant find either column "" or the user-defined function or aggregate "", or the name is ambiguous

Question

CREATE FUNCTION Person_Details (@P_ID int)
RETURNS TABLE
AS
RETURN(SELECT Person_ID,P_F_Name 
FROM Person_tbl
WHERE Person_ID=@P_ID) 

SELECT dbo.Person_Details(1)

--WHAT SHOULD I DO HERE BECAUSE IM STILL A NEWBIE

Answer 1

Try:

SELECT * FROM dbo.Person_Details(1)