数据表之间的联合查询,大致可以分为内连接、左连接、右连接和全连接。
表event
表area
--内连接
select * from event, area where event.sip=area.ip;
select * from event inner join area on event.sip=area.ip;
--左连接
select * from event left outer join area on event.sip=area.ip;
--右连接
select * from event right outer join area on event.sip=area.ip;
--全连接
select * from event full join area on event.sip=area.ip;
其中,inner、outer关键字可以省略