-- Temprary Table の作成 --
WITH trump AS (SELECT * FROM ( VALUES
('♦',1),('♦',2),('♦',3),('♦',4),('♦',5),('♦',6),('♦',7),('♦',8),('♦',9),('♦',10),('♦',11),('♦',12),('♦',13),
('♤',1),('♤',2),('♤',3),('♤',4),('♤',5),('♤',6),('♤',7),('♤',8),('♤',9),('♤',10),('♤',11),('♤',12),('♤',13),
('♣',1),('♣',2),('♣',3),('♣',4),('♣',5),('♣',6),('♣',7),('♣',8),('♣',9),('♣',10),('♣',11),('♣',12),('♣',13),
('♡',1),('♡',2),('♡',3),('♡',4),('♡',5),('♡',6),('♡',7),('♡',8),('♡',9),('♡',10),('♡',11),('♡',12),('♡',13),
('joker',0)
) AS t(symbol,number))
-- 以下，temporary table: trump を用いてのクエリ --
SELECT n1.symbol,n2.symbol, n1.number, n2.number
FROM
(
  SELECT number, symbol
  FROM trump
  WHERE symbol!='joker'
) n1
JOIN
(
  SELECT number, symbol
  FROM trump
  WHERE symbol!='joker'
) n2
ON n1.symbol != n2.symbol
ORDER BY n1.symbol, n2.symbol, n1.number, n2.number