本文主要是介绍sql92语句与sql99语法的区别，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
场景:测试sql92语句与sql99语法的区别
–创建测试表
CREATE table ypg_08161 as
select ‘1’ as id ,‘one’ as c_name
union all
select ‘2’ as id ,‘two’ as c_name
CREATE table ypg_08162 as
select ‘1’ as id ,‘male’ as c_sex
union all
select ‘3’ as id ,‘female’ as c_sex
第一类:inner join
–sql92语法
select a.id, a.c_name, b.c_sex from ypg_08161 a, ypg_08162 b where a.id=b.id;
id c_name c_sex
1 one male
–sql99语法
select a.id, a.c_name, b.c_sex from ypg_08161 a join ypg_08162 b on a.id=b.id;
id c_name c_sex
1 one male
第二类:left join
–sql92语法
select a.id, a.c_name, b.c_sex from ypg_08161 a, ypg_08162 b where a.id=b.id(+);
id c_name c_sex
1 one male
2 two null
–sql99语法
select a.id, a.c_name, b.c_sex from ypg_08161 a left join ypg_08162 b on a.id=b.id;
id c_name c_sex
1 one male
2 two null
这篇关于sql92语句与sql99语法的区别的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
