3
SELECT field1
FROM tbl1
WHERE conditionsx

...?

SELECT field2
FROM tbl2
WHERE conditionsy

I Want return same below↓ What is superscription between two SELECT results.

enter image description here

forpas
  • 160,666
  • 10
  • 38
  • 76
parmer_110
  • 325
  • 2
  • 11

1 Answers1

3

You can use the INTERSECT operator:

SELECT field1 FROM tbl1 WHERE conditionsx
INTERSECT
SELECT field2 FROM tbl2 WHERE conditionsy
forpas
  • 160,666
  • 10
  • 38
  • 76