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, n3.symbol, n1.number, n2.number, n3.number
FROM
(
  SELECT symbol,number
  FROM trump
) n1,
(
  SELECT symbol,number
  FROM trump
) n2,
(
  SELECT symbol,number
  FROM trump
) n3
ORDER BY n1.symbol, n2.symbol, n3.symbol, n1.number, n2.number, n3.number