beautypg.com

HP Intelligent Management Center Standard Software Platform User Manual

Page 681

background image

every customer who has not placed any orders. These customers appear at
the end of the list with blanks in the fields that would otherwise hold order
information:

Orders Table

Customer Table

Customer Table

Order Amount

Customer Name

Customer ID

25141.50

Allez Distribution

52

19164.30

BG Mountain Inc.

53

1683.60

BG Mountain Inc.

53

15716.40

Hansen MTB Inc.

57

1956.20

La Bomba de Bicicleta

58

24580.50

Mountain Toad

60

7911.80

SFB Inc.

62

19766.20

Sierra Bicycle Group

63

12763.95

Sierra Bicycle Group

63

8233.50

Sierra Mountain

64

Bicicletas Aztecas

54

Crystal Reports 2008 SP3 User's Guide

681

25

Understanding Databases

Linking tables