SQL Examples

Product Information > JADE External Interface Developer’s Reference > Chapter 2 - Using External Interfaces > SQL Examples

SQL Examples

The following subsections give some examples of SQL statements that can be applied to relational views that have been created from a fictitious JADE database.

Accessing Classes and Subclasses Using SQL

Accessing Relationship Views Using SQL

One-to-One Relationship

One-to-Many Relationship

Many-to-Many Relationship

Collections

Collection Methods