Hi,

please I would to know how can I obtain the AND of these two selects, I would want to obtain the INTERSECTION instead of UNION.

(
SELECT tab1.ID_tab1
FROM tab1
WHERE (
(
(
tab1.fld01 LIKE '%ke%'
OR tab1.fld02 LIKE '%ke%'
OR tab1.fld03 LIKE '%ke%'
OR tab1.fld04 LIKE '%ke%'
OR tab1.fld05 LIKE '%ke%'
OR tab1.fld06 LIKE '%ke%'
OR tab1.fld07 LIKE '%ke%'
OR tab1.fld08 LIKE '%ke%'
OR tab1.fld09 LIKE '%ke%'
OR tab1.fld10 LIKE '%ke%'
OR tab1.fld11 LIKE '%ke%'
OR tab1.fld12 LIKE '%ke%'
OR tab1.fld13 LIKE '%ke%'
OR tab1.fld14 LIKE '%ke%'
)
OR (

SELECT tab1.ID_tab1
FROM tab2, tab1
WHERE tab2.fld01 LIKE '%ke%'
AND tab1.ID_tab2 = tab2.ID_tab2
)
OR (

SELECT tab1.ID_tab1
FROM tab3, tab1
WHERE (
(
tab3.fld01 LIKE '%ke%'
OR tab3.fld02 LIKE '%ke%'
OR tab3.fld03 LIKE '%ke%'
OR tab3.fld04 LIKE '%ke%'
OR tab3.fld05 LIKE '%ke%'
OR tab3.fld06 LIKE '%ke%'
OR tab3.fld07 LIKE '%ke%'
OR tab3.fld08 LIKE '%ke%'
OR tab3.fld09 LIKE '%ke%'
OR tab3.fld10 LIKE '%ke%'
)
AND tab1.ID_tab3 = tab3.ID_tab3
)
)
)
)
)
UNION (

SELECT tab1.ID_tab1
FROM tab4, tab6, tab5, tab3, tab1
WHERE 1 =1
AND tab4.tab4 LIKE '%This word%'
AND tab4.ID_tab4 = sub_tab4.ID_tab4
AND tab6.ID_tab6 = tab5.ID_tab6
AND tab5.ID_tab5 = tab3.ID_tab5
AND tab3.ID_tab3 = tab1.ID_tab3
)

The real select I consider is similar like that. Is it possible to do the intersection? I am trying all combination without success. In this case obviously I obtain results from the first select in addition to the results of the second select.... but I don't want this

many thanks to all indeed!!