What are the breed names and eye colour of dogs with wiry coats?
The combination of the data in these two tables accomplished via a join creates a complex table. The amended SQL*Plus statement now resembles the following: SQL> select breed_typ, group_name, eye_colour from DOG, FEATURES where dog.breed_typ = features.breed_typ and coat_typ = wiry’ order by breed_typ; SQL would join the tables and locate the following dog breeds: Breed_typ Group_name Eye_colour Cairn Terrier Brown Lakeland Terrier Brown 2 records selected. There are many kinds of joins which can be performed in ORACLE; the example above showed an “equijoin”, another type is defined as an “outer join” or a “non-equijoin” and involves combining 2 or more tables with disparate column (or field) values.
