how understand one result set is subset of another in twomysql select result set ?
- by Ehsan Khodarahmi
Hi
I've 2 mysql select statements, suppose these are my queries & their result :
Statement 1 :
select id from a
which returns this result set : { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }
Statement 2 :
select id from b
which returns this result set : { 3, 5, 10 }
I want to write a query which determines whether resultset1 contains all records of resultset2 or not. I think needs a simple query, any suggestion ???
