左连接
select .... from
lefttable left join righttable
on 关联条件
例:select * from
t_student left join t_class
on t_student.cid=t_class.cid;
右连接
select .... from
lefttable right join righttable
on 关联条件
左连接
select .... from
lefttable left join righttable
on 关联条件
例:select * from
t_student left join t_class
on t_student.cid=t_class.cid;
右连接
select .... from
lefttable right join righttable
on 关联条件