|
|
|
Views typically have view columns whose data comes from a table referenced in one of the joins on that view.
If a view column references a table that is not joined in, then this is an implicit cross join.
If a view does not have any joins, and the view columns do not all come from the same table, then this is also an implicit cross join.
Note: There are baseline views that have implicit cross joins.
For example, consider the baseline view case2rip_dfe:
View Columns:
View Column |
Table |
Column |
|---|---|---|
case_id |
case |
objid |
dfe_id |
disptchfe |
objid |
rip_id |
case |
ripbin |
Joins:
Join From |
Join To |
|---|---|
disptchfe.disptchfe2case |
case.case_onsite2disptchfe |
This view has view columns coming from three tables: case, disptchfe, and ripbin. But there is only one join: from disptchfe to case. This means that the join to ripbin is an implicit cross join. Note that this is not the typical use of views and joins.
Dovetail SchemaEditor will read in these existing views from the database and from a Data Dictionary file.
However, Dovetail SchemaEditor does not fully support modifications of views with implicit cross joins:
Dovetail SchemaEditor does allow these views to be deleted/dropped.
See Also |
Next |