Skip to Content
author's profile photo Sai Tharun
-3
Sai Tharun
Mar 12, 2019 at 08:07 AM

select records where the two fields has different values each

170 Views Last edit Mar 12, 2019 at 08:09 AM 2 rev

I have a table, where field1 and field2 as shown below.

field1 field2
x 'ab'
x 'bc'
y 'cs'
y 'hg'
y 'sk'
y 'kj'

now i have to select a,b where a in (field2 of x) and b in (field2 of y)