Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 2.6

FEATURE

Dealing with Databases

Learning SQL Part 2

Issue: 2.6 (July/August 2004)
Author: Jonathan Johnson
Author Bio: Jonathan Johnson is a Tester for REAL Software. He has done database contract work for two years, and continues to work with databases almost every day.
Article Description: No description available.
Article Length (in bytes): 9,483
Starting Page Number: 27
Article Number: 2612
Related Link(s): None

Excerpt of article text...

In the previous installment, we learned the basics of the SQL SELECT statement. However, there are more features to it. Aggregate functions can do math for you and ORDER BY and GROUP BY statements provide helpful data organization, and queries can span multiple tables to help link related tables together. We'll also learn how to put data into the database with the INSERT statement and change it with the UPDATE statement.

For the examples in this tutorial, we'll assume two tables: Customers and Orders. The databases will be related so that each order has a customer number.

Aggregate Functions

...End of Excerpt. Please purchase the magazine to read the full article.