随笔分类 -  postgresql

摘要:上面为表结构 下面则为 相关函数写法 写这些主要是为了学习下与Oracle的区别 SELECT * FROM STUDENT CROSS JOIN TEACHER;--交叉连接 SELECT * FROM STUDENT S INNER JOIN TEACHER T ON S.TEACHER_ID=T.ID;--内连接 SELECT * FROM STUDENT S LEFT OUTER J... 阅读全文
posted @ 2018-12-07 15:10 FlatWang 阅读(130) 评论(0) 推荐(0)