答案:select a.*,case when b.column is not null then 'ture' else 'false' end
from a left join b on a.column=b.column;
其中a.column=b.column就是连接关系
其他:select a.*,a.column,'true' from a,b where a.column=b.column
union all
select a.*,a.column,'false' from a where not exists(select b.column from b where a.column=b.column)
上一个:怎么修改oracle Net Configuration Assistant配置的网络环境
下一个:oracle 表导入失败,具体出错如下: 连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0