combination_trump_triplet.sql

SELECT n1.number, n2.number, n3.number, n1.symbol, n2.symbol, n3.symbol
FROM
(
  SELECT symbol,number
  FROM trump
) n1,
(
  SELECT symbol,number
  FROM trump
) n2,
(
  SELECT symbol,number
  FROM trump
) n3
ORDER BY n1.number, n2.number, n3.number, n1.symbol, n2.symbol, n3.symbol