Intersect

MATLAB equivalents of SQL JOINS can be done using the intersect function

test=intersect(find(M(:,2)==30), find(M(:,3)==30))