Create table Suppliers (SId int, Name varchar(10), Address varchar(20) )
go
insert into suppliers values(1, 's1', 'add1' )
insert into suppliers values(2, 's2', 'add2' )
insert into suppliers values(3, 's3', 'add3' )
insert into suppliers values(4, 's4', 'add4' )
go
Create table Parts (PId int, Name varchar(10), Color varchar(20))
insert into parts values(1, 'p1', 'c1')
insert into parts values(2, 'p2', 'c2')
insert into parts values(3, 'p3', 'c3')
go
Create table Catalog (SId int, PId int)
go
insert into catalog values(1, 1)
insert into catalog values(2, 1)
insert into catalog values(2, 2)
insert into catalog values(2, 3)
insert into catalog values(3, 2)
insert into catalog values(3, 3)
insert into catalog values(4, 2)
go

SELECT a.suppliername, * FROM 
(
SELECT SId, s.Name SupplierName, Address, PId, p.Name PartName, Color
FROM suppliers s cross join parts p
) a 
left join catalog c on c.sid = a.sid and c.pid = a.pid
WHERE c.sid is not null and c.pid is not null

SELECT a.suppliername FROM 
(
SELECT SId, s.Name SupplierName, Address, PId, p.Name PartName, Color
FROM suppliers s cross join parts p
) a 
left join catalog c on c.sid = a.sid and c.pid = a.pid
GROUP BY a.suppliername
HAVING COUNT(*)-COUNT(c.pid)=0