Advertisement

Hiding Complex SQL with Views

  • Cristian Darie
  • Karli Watson
  • Chris Hart
  • Kevin Hoffman
  • Julian Skinner

Abstract

So far, when you’ve wanted to restructure data with calculated columns or extract data from multiple tables based on comparisons between column values, you’ve had to resort to relatively complex SQL statements. Typically, though, you’ll want to obtain data in this modified form more than once. Certain tasks, such as getting the name of the customer associated with an order, will be performed so often that it can seem awkward to have to query multiple tables all the time.

Keywords

View Statement Aggregate Function Monday Morning Virgin State Multiple Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Cristian Darie, Karli Watson with Chris Hart, Kevin Hoffman, Julian Skinner 2003

Authors and Affiliations

  • Cristian Darie
  • Karli Watson
  • Chris Hart
  • Kevin Hoffman
  • Julian Skinner

There are no affiliations available

Personalised recommendations