USE Master
GO
CREATE DATABASE Noticias
GO
 
USE Noticias
GO
 
CREATE TABLE Noticias(
	idNoticia INT PRIMARY KEY,
	nombre VARCHAR(50)
	)
 
CREATE TABLE Fotos(
	idFoto INT PRIMARY KEY,
	noticia INT FOREIGN KEY REFERENCES Noticias(idNoticia)
	)
GO
 
INSERT INTO Noticias VALUES(1, 'noticia 1');
INSERT INTO Noticias VALUES(2, 'noticia 2');
INSERT INTO Noticias VALUES(3, 'noticia 3');
INSERT INTO Noticias VALUES(4, 'noticia 4');
 
INSERT INTO Fotos VALUES(1, 1);
INSERT INTO Fotos VALUES(2, 1);
INSERT INTO Fotos VALUES(3, 1);
INSERT INTO Fotos VALUES(4, 2);
 
GO
 

SELECT nombre, foto
FROM noticias LEFT JOIN (
	SELECT  noticia, MAX(idfoto) AS foto
	FROM fotos
	GROUP BY noticia
	) AS fotos
	ON noticias.idNoticia = fotos.noticia