Tables Announcements Joining Tables Reminder: John the Patriotic - PowerPoint PPT Presentation

Tables

Announcements

Joining Tables

Reminder: John the Patriotic Dog Breeder E isenhower F illmore A braham D elano G rover B arack C linton H erbert � 4

Reminder: John the Patriotic Dog Breeder E isenhower SELECT "abraham" AS parent, "barack" AS child UNION F illmore SELECT "abraham" , "clinton" UNION SELECT "delano" , "herbert" UNION SELECT "fillmore" , "abraham" UNION A braham D elano G rover SELECT "fillmore" , "delano" UNION SELECT "fillmore" , "grover" UNION B arack C linton H erbert SELECT "eisenhower" , "fillmore"; � 4

Reminder: John the Patriotic Dog Breeder E isenhower CREATE TABLE parents AS SELECT "abraham" AS parent, "barack" AS child UNION F illmore SELECT "abraham" , "clinton" UNION SELECT "delano" , "herbert" UNION SELECT "fillmore" , "abraham" UNION A braham D elano G rover SELECT "fillmore" , "delano" UNION SELECT "fillmore" , "grover" UNION B arack C linton H erbert SELECT "eisenhower" , "fillmore"; � 4

Reminder: John the Patriotic Dog Breeder Parents: E isenhower Parent Child CREATE TABLE parents AS abraham barack SELECT "abraham" AS parent, "barack" AS child UNION F illmore abraham clinton SELECT "abraham" , "clinton" UNION delano herbert SELECT "delano" , "herbert" UNION fillmore abraham SELECT "fillmore" , "abraham" UNION A braham D elano G rover fillmore delano SELECT "fillmore" , "delano" UNION fillmore grover SELECT "fillmore" , "grover" UNION B arack C linton H erbert SELECT "eisenhower" , "fillmore"; eisenhower fillmore � 4

Joining Two Tables � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION A � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION SELECT "barack" , "short" UNION A B � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION A B C � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION A D B C � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION A D B C � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION F SELECT "fillmore" , "curly" UNION A D B C � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION F SELECT "fillmore" , "curly" UNION SELECT "grover" , "short" UNION A D G B C � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION F SELECT "fillmore" , "curly" UNION SELECT "grover" , "short" UNION SELECT "herbert" , "curly"; A D G B C H � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION F SELECT "fillmore" , "curly" UNION SELECT "grover" , "short" UNION SELECT "herbert" , "curly"; CREATE TABLE parents AS SELECT "abraham" AS parent, "barack" AS child UNION A D G SELECT "abraham" , "clinton" UNION ...; B C H � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION F SELECT "fillmore" , "curly" UNION SELECT "grover" , "short" UNION SELECT "herbert" , "curly"; CREATE TABLE parents AS SELECT "abraham" AS parent, "barack" AS child UNION A D G SELECT "abraham" , "clinton" UNION ...; Select the parents of curly-furred dogs B C H � 5

Joining Two Tables Two tables A & B are joined by a comma to yield all combos of a row from A & a row from B CREATE TABLE dogs AS SELECT "abraham" AS name, "long" AS fur UNION E SELECT "barack" , "short" UNION SELECT "clinton" , "long" UNION SELECT "delano" , "long" UNION SELECT "eisenhower" , "short" UNION F SELECT "fillmore" , "curly" UNION SELECT "grover" , "short" UNION SELECT "herbert" , "curly"; CREATE TABLE parents AS SELECT "abraham" AS parent, "barack" AS child UNION A D G SELECT "abraham" , "clinton" UNION ...; Select the parents of curly-furred dogs B C H SELECT parent FROM parents, dogs WHERE child = name AND fur = "curly"; � 5