MySql：联合查询

* FROM employees WHERE email LIKE ‘ %a% ‘ OR department_id > 90 ;; SELECT * FROM employees WHERE email LIKE ‘ %a% ‘ UNION SELECT * FROM employees WHERE department_id > 90 ;

#案例：查询中国用户中男性的信息以及外国用户中年男性的用户信息

 SELECT  id,cname  FROM  t_ca  WHERE  csex =  ‘  男  ‘ 
 UNION   ALL 
 SELECT  t_id,tname  FROM  t_ua  WHERE  tGender =  ‘  male  ‘ ;

 

MySql：联合查询

标签：默认   ike   特点   sele   使用   语法   一个   rgb   cse   

查看更多关于MySql：联合查询的详细内容...