If an object is defined within another object, you can query such an object by using standard SQL and dot notation.
You can drill down to the simple data type with dot notation.
Let's look at the following MouseOver that queries CUSTOMER_OBJ_TABLE, which is associated with the ADDRESS_TYPE object. To query based on a particular state within the address, you have to drill down to the STATE attribute within the ADDRESS_TYPE object by using dot notation, as described in the following MouseOver:
The following Tooltip illustrates an example of querying an object table where one object is associated with another object: