<二>Oracle多表主键外键+inner join/left join/right join

新建两张表table test

和table foreignTable

sql语句：

select t.*, t.rowid from TEST tinsert into test values('','1','11')insert into test values('ning','0','22')insert into test values('chen','1','33')--要创建该字段，首先要保证外键‘chen’这个字段在foreignTable这张表中存在，即为该表的主键delete from test where name='chenning'select * from testupdate test set sex='2' where id='11' select * from foreignTableinsert into foreignTable values('ning','test')insert into foreignTable values('chen','testchen')select s.* from foreignTable s where s.name in (select t.name from test t)select s.*,t.* from foreignTable s inner join test t on s.name=t.name--只显示符合条件的记录select s.*,t.* from foreignTable s left join test t on s.name=t.name--左连接，以左表s为基准，显示左表的所有记录，右表t显示符合条件的记录，右表t记录不足的地方均为NULLselect s.*,t.* from foreignTable s right join test t on s.name=t.name--右连接，以右表t为基准，显示右表的所有记录，左表s显示符合条件的记录，左表s记录不足的地方均为NULL