Query di selezione

SELECT ....
FROM tabella alberghi AS A
JOIN tabella mov_alberghi AS M
ON A.codalbergo = M.codalbergo 
AND A.codcomune = M.codcomune
WHERE...;

ALTER PROCEDURE [dbo].[GetLastDate] 
(
@CodAlb Int,
@CodComAlb Int
)
AS
BEGIN
SELECT albergo.codalb,albergo.codcomune,MAX(Archivio_mov.data_elaborazione)As data
FROM albergo 
JOIN archivio_mov 
ON albergo.codalb = archivio_mov.codalbergo 
AND albergo.codcomune = archivio_mov.codcomune
WHERE albergo.codalb=@Codalb AND albergo.codcomune=@CodComAlb
END

ALTER PROCEDURE [dbo].[GetLastDate] 
(
@CodAlb Int,
@CodComAlb Int
)
AS
BEGIN

SELECT 
    a.codalb
  , a.codcomune
  , data = MAX(m.data_elaborazione)
FROM 
  albergo a
JOIN archivio_mov m ON a.codalb = m.codalbergo AND a.codcomune = m.codcomune
WHERE 
  a.codalb = @Codalb AND a.codcomune=@CodComAlb
GROUP BY
    a.codalb
  , a.codcomune
  
END

ALTER PROCEDURE [dbo].[GetLastDate] 
(
@CodAlb Int,
@CodComAlb Int
)
AS
BEGIN

SELECT 
    a.codalb
  , a.codcomune
  , CASE 
        WHEN MAX(m.data_elaborazione) IS NULL THEN 'Nessuna data'
        ELSE MAX(m.data_elaborazione)
    END AS Data
FROM 
  albergo a
LEFT JOIN archivio_mov m 
ON a.codalb = m.codalbergo AND a.codcomune = m.codcomune
WHERE 
  a.codalb = @Codalb AND a.codcomune=@CodComAlb
GROUP BY
    a.codalb
  , a.codcomune
  
END