查询表有如下数据:SQL> select count(*) from material.materialiohis
2 where barcode = 'A0015'; COUNT(*)
----------
25查询视图有如下数据:
SQL> select count(*) from material.mat_3m_vs_on_way
2 where barcode = 'A0015'; COUNT(*)
----------
14Join之后怎么会没有匹配到呢?结果如下:SQL> select count(*) from material.materialiohis a,
2 material.mat_3m_vs_on_way b
3 where a.barcode = b.barcode
4 and a.barcode = 'A0015'; COUNT(*)
----------
350是不是视图与表不能进行Join,原理是什么?请帮忙分析一下!
2 where barcode = 'A0015'; COUNT(*)
----------
25查询视图有如下数据:
SQL> select count(*) from material.mat_3m_vs_on_way
2 where barcode = 'A0015'; COUNT(*)
----------
14Join之后怎么会没有匹配到呢?结果如下:SQL> select count(*) from material.materialiohis a,
2 material.mat_3m_vs_on_way b
3 where a.barcode = b.barcode
4 and a.barcode = 'A0015'; COUNT(*)
----------
350是不是视图与表不能进行Join,原理是什么?请帮忙分析一下!
你这不是有数据嘛