Post
Ask Question

Get Common Records from two tables without join and subquery

suppose Table_1 has following records
      Sal           
      100
      200
      300 
 
 Table_2 has following records
sal1
100
200
300
400
  1. select *from Table_1  
  2. intersect   
  3.   
  4. select *from Table_2 
Output will be
 Sal
100
200
300