Monday, May 16, 2016

Union Example in Mysql

select * from registration where state in('MH') and taluka in('NANDED','HINGOLI') 
union 
select * from registration where state in('TS') and taluka in('NANDED','KHAIRATABAD','HYDERABAD');

select * from registration where team in('dev') and role_name in(2,3)
union 
select * from registration where team in('it') and role_name in(1,2,3);