taking out common data using sql : i want to compare two  column and take out the common rows which are present in table1 and table 2 from two different tables. 


table 1		      table 2		      result                                        mobnum A		 mobnum B		     988123456  		
988123456        988124567201718	 988123457			  
988124567		 988123456201718		
944123456        988623456201718		