black Posted May 30, 2007 Report Share Posted May 30, 2007 nezinu vai derēs: SELECT anketetajs, COUNT(anketetajs) cnt FROM ( SELECT DISTINCT anketetajs FROM whatever1 UNION SELECT DISTINCT anketetajs whatever2) GROUP BY anketetajs HAVING cnt=2 Link to comment Share on other sites More sharing options...
Recommended Posts