Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
[Blue]SELECT[/Blue] Y1.Fld1 [Blue]FROM[/Blue] YourTable Y1
[Blue]INNER[/Blue] [Gray]JOIN[/Gray] YourTable Y2
[Blue]ON[/Blue] Y1.Fld1[Gray]=[/Gray]Y2.Fld2
[Blue]WHERE[/Blue] Y1.Fld2[Gray]=[/Gray]2 [Gray]AND[/Gray] Y2.Fld2[Gray]=[/Gray]13
select Y1.Fld1
from YourTable Y1
inner join YourTable Y2 on Y1.fld1=Y2.[b]fld1[/b]
where Y1.fld2=2 and Y2.fld2=13
select distinct A.Fld1
from YourTable A
where exists(select * from YourTable B where B.Fld1=A.fld1 and Fld2=2)
and exists(select * from YourTable B where B.Fld1=A.fld1 and Fld2=13)
select Fld1
from
( select Fld1, Fld2
from YourTable
where Fld2 in (2, 13)
group by Fld1, Fld2
) X
group by Fld1
having count(*) = 2
select Fld1
from YourTable
where Fld2 in (2, 13)
group
by Fld1
having count(*) = 2
select Fld1
from YourTable
where Fld2 in (2, 13, 937)
group
by Fld1
having count(*) = 3
select Fld1
from YourTable
where Fld2 in (2, 13)
group
by Fld1
having count([b]distinct Fld2[/b]) = 2