Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following two relations City table Cno cname 1 kochi 2 . Delhi 3 . Bangalore Flight table Fno Startfrom F 1 bombay F
Consider the following two relations
City table
Cno cname
kochi
Delhi
Bangalore
Flight table
Fno Startfrom
F bombay
F kochi
F Delhi
Select cF from city c left join flight where c c name Fstart from;
Select cF from city c right join flight where c c name Fstart from;
What are the outputs for above two queries
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started