Re: Sakila giving some strange results
select city.city_id, city, address.district, country from city left outer join country on city.country_id = country.country_id left outer join address on city.city_id = address.city_id where city_id = 312 or city_id = 313;
The query returns 3 records
312 London England United Kingdom
312 London Ontario United Kingdom
313 London NULL Canada
The addresses that are showing up also look like the records in the table have moved because the London store addresses more likely belong to stores in China and other South Asian countries.
Could someone please recommend a good book or online resource for learning SQL. Especially, if there is some place where one can find queries given in English that have to be converted to sql.
Thank you in advance.
Saleem
Subject
Written By
Posted
Re: Sakila giving some strange results
April 07, 2015 01:32AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.