Skip to content

Instantly share code, notes, and snippets.

@Pickman-Model

Pickman-Model/Mysql之UNION的使用.sql

Created July 27, 2016 15:19
Show Gist options
  • Save Pickman-Model/68d5105e264c104fcd989049e2f34d4f to your computer and use it in GitHub Desktop.
Save Pickman-Model/68d5105e264c104fcd989049e2f34d4f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Mysql之UNION的使用.sql
(select fid,name from addr_tbl where id = (select fid from addr_tbl where id = (select fid from addr_tbl where id = 1)) and dep > 0 ) union (select fid,name from addr_tbl where id = (select fid from addr_tbl where id = 1) ) union (select fid,name from addr_tbl where id = 1);
//嵌套关系数据库，拼接结果集
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment