Previous Next JavaScript must be enabled to correctly display this content

## Examples using Left Outer Joins

Various tables used in the examples :

- `ticket`

      ticketNo LONG
      confNo STRING
      PRIMARY KEY(ticketNo)

- `ticket.bagInfo`

      id LONG
      tagNum LONG
      routing STRING
      lastActionCode STRING
      lastActionDesc STRING
      lastSeenStation STRING,
      lastSeenTimeGmt TIMESTAMP(4)
      bagArrivalDate TIMESTAMP(4)
      PRIMARY KEY(id)

- `ticket.bagInfo.flightLegs`

      flightNo STRING
      flightDate TIMESTAMP(4)
      fltRouteSrc STRING
      fltRouteDest STRING
      estimatedArrival TIMESTAMP(4),
      actions JSON
      PRIMARY KEY(flightNo)

- `ticket.passengerInfo`

      contactPhone STRING
      fullName STRING
      gender STRING
      PRIMARY KEY(contactPhone)

- SQL Examples
- Query API examples