[odb-users] Initial load with join

[Boris Kolpackov]

Hi Paul,

Stath, Paul <PStath at Axxcelera.com> writes:

> I assume this "object loading view" would result in a new VIEW in the
> database schema that is contains an INNER JOIN with the related tables
> with appropriate join conditions for the relationships.

No, ODB views are not mapped to database views. Quoting from Chapter 10
in the ODB manual:

"Many relational databases also define the concept of views. Note, however,
that ODB views are not mapped to database views. Rather, by default, an ODB
view is mapped to an SQL SELECT query. However, if desired, it is easy to
create an ODB view that is based on a database view."

In this particular case you will have a single SELECT statement with
two JOIN's (one for JobSheet and the other for Address) which will load
all three objects at once.

Boris