1.合并查询结果
将两张表的数据合并在一起
先查看两张表的内容:select * from t_book;
select * from t_booktype;
将两张表的id属性合并,有:
select id from t_book union select id from t_booktype;
若想合并后不消除共同属性有:
select id from t_book union all select id from t_booktype;
2.为表和字段取别名
2.1为表取别名
表名 表别名;
select * from t_book where id=1;
取别名:select * from t_book tb where tb.id=1;
查询结果是一样的;
2.2为字段取别名
属性名 [AS] 别名
select bookName as bn from t_book tb where tb.id=1;