1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| drop table if exists tmpNrssListe;
CREATE TABLE tmpNrssListe
select nrss, numfichier as fic , numFichier as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from tactext_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, numFichier as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from targu_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, numFichier as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from tdivact_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, numFichier as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from tdivdas_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, numFichier as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsaact_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, numFichier as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsadas_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, numFichier as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsafix_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, numFichier as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsardth_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, numFichier as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trsaum_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, numFichier as trssact_fu, null as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trssact_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, numFichier as trssdad_fu, null as trssdas_fu, null as trssfix_fu from trssdad_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, numFichier as trssdas_fu, null as trssfix_fu from trssdas_fu where numFichier is not null
union
select nrss, numfichier as fic , null as tactext_fu, null as targu_fu, null as tdivact_fu, null as tdivdas_fu, null as trsaact_fu, null as trsadas_fu, null as trsafix_fu, null as trsardth_fu, null as trsaum_fu, null as trssact_fu, null as trssdad_fu, null as trssdas_fu, numFichier as trssfix_fu from trssfix_fu where numFichier is not null
order by nrss, fic; |
Partager