Writing the MERGE control statement

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:

Merging the bookstore master data set with the data set containing the five new records

Table 1 shows the merged output.

Table 1. Sample Bookstore Data Set Merged with Five New Records
Book 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