select distinct concat(mid('例如传入',t1.x,1) ,mid('例如传入',t2.x,1) ,mid('例如传入',t3.x,1) ,mid('例如传入',t4.x,1) )
from (
select 1 as x union all
select 2 union all
select 3 union all
select 4
) t1,
(
……
[/Quote]
select distinct concat(mid('例如传入',t1.x,1) ,mid('例如传入',t2.x,1) ,mid('例如传入',t3.x,1) ,mid('例如传入',t4.x,1) )
from (
select 1 as x union all
select 2 union all
select 3 union all
select 4
) t1,
(
select 1 as x union all
select 2 union all
select 3 union all
select 4
) t3,
(
select 1 as x union all
select 2 union all
select 3 union all
select 4
) t3,
(
select 1 as x union all
select 2 union all
select 3 union all
select 4
) t4