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
|
select documentsactifs.numdoc from documentsactifs where (to_ascii(documentsactifs.titre,'LATIN1') like '%toto%')
union
select documentsactifs.numdoc from documentsactifs where (to_ascii(documentsactifs.soustitre,'LATIN1') like '%toto%')
union
select documentsactifs.numdoc from documentsactifs where (to_ascii(documentsactifs.sujet,'LATIN1') like '%toto%')
union
select documentsactifs.numdoc from documentsactifs where (to_ascii(documentsactifs.resume,'LATIN1') like '%toto%')
union
select documentsactifs.numdoc from documentsactifs where (to_ascii(documentsactifs.notelibre,'LATIN1') like '%toto%')
union
select distinct t.numdoc
from documentsactifs t join correspond d on t.numdoc = d.numdoc
join motclelibre m on d.nummotcle = m.nummotcle
where m.nommotcle in ('toto')
group by t.numdoc
having count(*) >= 1
union
select distinct t.numdoc
from documentsactifs t join trouve d on t.numdoc = d.numdoc
join champthesaurus m on d.numchampthesaurus = m.numchampthesaurus
where m.terme in ('toto')
group by t.numdoc
having count(*) >= 1 |
Partager