select *from Table_1
select *from table_6
select distinct*from table_6 --distinct去掉重复值
select *from table_6 where ok = (select ID from Table_1 where NAME=(select NAME from Table_1 where ok=789) )
--如果子查询返回的值为多个时、就不能用=比较运算符、必须要用in
select *from table_6 where ok in (select ID from Table_1 where NAME=(select name from Table_1 where ok=789) )
select *from table_6 where ok not in(select ID from Table_1 where NAME=(select NAME from Table_1 where ok=789))
--not in 与in就是相反了、就是用in能查到的结果都不会出现、比如表有1.2.3这几值、用in查到2、那用not in就是相反查到1.3