CREATE TABLE test
(   a NUMBER,
    b VARCHAR2(20 CHAR),
    c VARCHAR2(20 CHAR)
)

SELECT t.a, t2.b, t3.c FROM test t
  CROSS JOIN test t2
  CROSS JOIN test t3
  ORDER BY t.a, t2.b, t3.c;

CREATE TABLE IF NOT EXISTS `docs` (
  `id` int(6) unsigned NOT NULL,
  `A` int(3) unsigned NOT NULL,
  `B` varchar(10) NOT NULL,
  `C` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `docs` (`id`, `A`, `B`, `C`) VALUES
  ('1', '1', 'a', '!'),
  ('2', '2', 'b', '@');

SELECT CONCAT(t1.a,' ',t2.B,' ',t3.c)
FROM (SELECT DISTINCT A FROM docs) AS t1
CROSS JOIN (SELECT DISTINCT B FROM docs) AS t2
CROSS JOIN (SELECT DISTINCT C FROM docs) AS t3
order by t1.a, t2.b, t3.c

CREATE TABLE test (A varchar(10), B varchar(10),C varchar(10));
INSERT INTO test (A, B, C) VALUES ('1', 'a', '!');
INSERT INTO test (A, B, C) VALUES ('2', 'b', '@');

SELECT
  T.A,
  T2.B,
  T3.C
FROM
  test T
  CROSS JOIN test T2
  CROSS JOIN test T3
ORDER BY
  T.a,
  T2.b,
  T3.c;