select a.name, a.lastname, from myTable where b.name= a.lastname

CREATE PROCEDURE myProcedure
AS
BEGIN
SELECT [a.name],
       [a.lastname]
FROM [myTable]
WHERE [b.name] = a.lastname
END

SELECT RTRIM(l.Lab1) + '/' + RTRIM(l.LabR) AS Lab, meta.Title,ls.[ID],ls.[surveyID], ls.[specialistID],ls.[isCompleted] FROM [MyDIM].[dbo].[lsLabSurvey] ls JOIN [MYDIM].[dbo].[dimDocMetaInfo] meta ON meta.id = ls.[surveyID] and specialistID = @PID and isCompleted=1 JOIN MyDatabase.DBO.PID_Table l ON ls.ID = l.ID

CREATE PROCEDURE PROCD1
AS
BEGIN
SELECT RTRIM(l.Lab1) + '/' + RTRIM(l.LabR)
AS Lab,
   meta.Title,
   la.[ID],
   ls.[surveyID],
   ls.[specialistID],
   ls.[isCompleted]
FROM [MyDIM].[dbo].[lsLabSurvey] ls
JOIN [MyDIM].[dbo].[dimDocMetaInfo] meta
ON meta.id = ls.[surveyID]
and specialistID = @PID
and isCompleted=1
JOIN MyDatabase.DBO.PID_Table l
ON ls.ID = l.ID

CREATE PROCEDURE PROCD1 (@PID INT )
AS
    BEGIN
        SELECT  CONVERT(VARCHAR,RTRIM(l.Lab1)) + '/' + CONVERT(VARCHAR,RTRIM(l.LabR)) AS Lab ,
                meta.Title ,
                la.[ID] ,
                ls.[surveyID] ,
                ls.[specialistID] ,
                ls.[isCompleted]
        FROM    [MyDIM].[dbo].[lsLabSurvey] ls
                INNER JOIN [MyDIM].[dbo].[dimDocMetaInfo] meta ON meta.id = ls.[surveyID]
                INNER JOIN MyDatabase.DBO.PID_Table l ON ls.ID = l.ID
        WHERE   ls.specialistID = @PID
                AND ls.isCompleted = 1
    END
`

CREATE PROCEDURE SomeProcedureName
AS
select a.name, a.lastname, from myTable where b.name= a.lastname