几个关键字
IN --> select * from tablename where column in (select * from tablename)
exists -->
union (尽量不要用or逻辑)
union all
where 子查询条件顺序 从左往右
left join ----- out join
插入语句 最好把列名都写出来。
几个关键字
IN --> select * from tablename where column in (select * from tablename)
exists -->
union (尽量不要用or逻辑)
union all
where 子查询条件顺序 从左往右
left join ----- out join
插入语句 最好把列名都写出来。