I'm doing this with Valentina as the target database, but I don't think there is anything specific about the sql required for an intersect query.
My intersect query is using the same table (with different aliases) to find intersecting records (I know it is probably considered bad design).
Code: Select all
( SELECT a.linked_entity
FROM KEY_VALUE a
WHERE k = 'body' )
INTERSECT
( SELECT b.linked_entity
FROM KEY_VALUE b
WHERE
(locate('slow', v)>0)
And
(locate('network',v)>0)
)