SELECT field1
FROM tbl1
WHERE conditionsx
...?
SELECT field2
FROM tbl2
WHERE conditionsy
I Want return same below↓
What is superscription between two SELECT results.
>Solution :
You can use the INTERSECT operator:
SELECT field1 FROM tbl1 WHERE conditionsx
INTERSECT
SELECT field2 FROM tbl2 WHERE conditionsy
