Consider the following tables: Branch1 PropertyForRent1 branchNo bCity propertyNo pCity BO03 Glasgow PA14 Aberdeen BO04 Bristol PL94 London BO02 London PG4 Glasgow Create these two tables exactly as in the 1. figure above using SQL Developer or SQL Command Line 2. Provide Screenshots for the results obtained: 2.1 SELECT b.*, p.* FROM Branch1 b, PropertyForRent1 p WHERE b.bCity = p.pCity; 2.2 SELECT b.*, p.* FROM Branch1 b LEFT JOIN Implement the following Queries and PropertyForRent1 p ON b.bCity = p.pCity; 2.3 SELECT b.*, p.* FROM Branch1 b RIGHT JOIN PropertyForRent1 p ON b.bCity = %3D p.pCity; 2.4 SELECT b.*, p.* FROM Branch1 b FULL JOIN PropertyForRent1 p ON b.bCity = p.pCity;
Consider the following tables: Branch1 PropertyForRent1 branchNo bCity propertyNo pCity BO03 Glasgow PA14 Aberdeen BO04 Bristol PL94 London BO02 London PG4 Glasgow Create these two tables exactly as in the 1. figure above using SQL Developer or SQL Command Line 2. Provide Screenshots for the results obtained: 2.1 SELECT b.*, p.* FROM Branch1 b, PropertyForRent1 p WHERE b.bCity = p.pCity; 2.2 SELECT b.*, p.* FROM Branch1 b LEFT JOIN Implement the following Queries and PropertyForRent1 p ON b.bCity = p.pCity; 2.3 SELECT b.*, p.* FROM Branch1 b RIGHT JOIN PropertyForRent1 p ON b.bCity = %3D p.pCity; 2.4 SELECT b.*, p.* FROM Branch1 b FULL JOIN PropertyForRent1 p ON b.bCity = p.pCity;
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
Related questions
Question
![Consider the following tables:
Branch1
PropertyForRent1
branchNo
bCity
propertyNo
pCity
B003
Glasgow
PA14
Aberdeen
B004
Bristol
PL94
London
B002
London
PG4
Glasgow
1.
Create these two tables exactly as in the
figure above using SQL Developer or SQL
Command Line
2.
Provide Screenshots for the results obtained:
2.1
SELECT b.*, p.*
FROM Branch1 b, PropertyForRent1 p
WHERE b.bCity = p.pCity;
2.2
SELECT b.*, p.*
FROM Branch1 b LEFT JOIN
Implement the following Queries and
%3D
PropertyForRent1 p ON b.bCity =
p.pCity;
2.3
SELECT b.*, p.*
FROM Branch1 b RIGHT JOIN
PropertyForRent1 p ON b.bCity =
%3D
p.pCity;
2.4
SELECT b.*,
FROM Branch1 b FULL JOIN
р.*
PropertyForRent1 p ON b.bCity =
%3D
p.pCity;](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fcb342461-80e4-4e57-b99a-50bf870f7ef3%2Ffa729b6e-675f-425c-b229-c22596b07098%2Fnpo6c9_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Consider the following tables:
Branch1
PropertyForRent1
branchNo
bCity
propertyNo
pCity
B003
Glasgow
PA14
Aberdeen
B004
Bristol
PL94
London
B002
London
PG4
Glasgow
1.
Create these two tables exactly as in the
figure above using SQL Developer or SQL
Command Line
2.
Provide Screenshots for the results obtained:
2.1
SELECT b.*, p.*
FROM Branch1 b, PropertyForRent1 p
WHERE b.bCity = p.pCity;
2.2
SELECT b.*, p.*
FROM Branch1 b LEFT JOIN
Implement the following Queries and
%3D
PropertyForRent1 p ON b.bCity =
p.pCity;
2.3
SELECT b.*, p.*
FROM Branch1 b RIGHT JOIN
PropertyForRent1 p ON b.bCity =
%3D
p.pCity;
2.4
SELECT b.*,
FROM Branch1 b FULL JOIN
р.*
PropertyForRent1 p ON b.bCity =
%3D
p.pCity;
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning