SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 
 Oct  8 2022 05:58:25 
 Copyright (C) 2022 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table customer (CId int identity,Cname varchar(10));
insert into customer values('A'),('B');
create table product (PId int identity,Pname varchar(10));
insert into Product values('P1'),('P2'),('P3'),('P4');
create table CustomerProduct (CPId int identity,Cid int, Pid int);
insert into CustomerProduct values(1,1),(1,2),(2,1),(2,4);
10 rows affected

select *
from customer c
cross join product p
where not exists
(
  select null
  from customerproduct cp
  where cp.cid = c.cid and cp.pid = p.pid
);


CId
Cname
PId
Pname


1
A
3
P3

1
A
4
P4

2
B
2
P2

2
B
3
P3