The format of the MERGE statement
is the same as that of the SORT
statement. To merge the bookstore master data set with the data set
containing the five new records, write:
Table 1 shows the merged output.
Table 1. Sample
Bookstore Data Set Merged with Five New RecordsBook Title |
Course Department |
---|
1 75
|
110 114
|
INTERNATIONAL COOKBOOK
LIVING WELL ON A SMALL BUDGET
PICK'S POCKET DICTIONARY WORLD JOURNEYS BY TRAIN
ARTS AND CRAFTS OF ASIA
BIOCHEMISTRY
INTRODUCTION TO BIOLOGY
STRATEGIC MARKETING
SUPPLYING THE DEMAND
COMPUTER LANGUAGES
COMPUTERS: AN INTRODUCTION
NUMBERING SYSTEMS
SYSTEM PROGRAMMING
VIDEO GAME DESIGN
EDITING SOFTWARE MANUALS
INKLINGS: AN ANTHOLOGY OF YOUNG POETS
MODERN ANTHOLOGY OF WOMEN POETS
SHORT STORIES AND TALL TALES
THE COMPLETE PROOFREADER
CRISES OF THE MIDDLE AGES
EIGHTEENTH CENTURY EUROPE
THE INDUSTRIAL REVOLUTION
ADVANCED TOPICS IN PSYCHOANALYSIS BEHAVIORAL ANALYSIS
INTRODUCTION TO PSYCHOLOGY
|
ART
BIOL
BIOL
BUSIN
BUSIN
COMP
COMP
COMP
COMP
COMP
ENGL
ENGL
ENGL
ENGL
ENGL
HIST
HIST
HIST
PSYCH PSYCH
PSYCH
|