Why can't I SELECT a parent field that doesn't have a child?

Posted by myaccount on Stack Overflow See other posts from Stack Overflow or by myaccount
Published on 2010-04-28T10:39:14Z Indexed on 2010/04/28 10:43 UTC
Read the original article Hit count: 151

Filed under:

select

|

parent

|

child

|

foreign

|

keys

(rest_branches) is the table of restaurants.

(phone_numbers) is another table which contains the restaurants phone_numbers, and it has a field called (branch_id) which references the restaurant id.

When I try:

SELECT * 
FROM rest_branches
NATURAL JOIN phone_numbers

I only get the restaurants which have a phone_number. What should I do to get all restaurants even if they don't have a phone number?

© Stack Overflow or respective owner

Related posts about select

HTML muliple select should look like HTML select

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am trying to use a HTML select box with 'multiple' select options and size to 1 as below ` <SELECT NAME="toppings" MULTIPLE SIZE=5> <OPTION VALUE="mushrooms">mushrooms <OPTION VALUE="greenpeppers">green peppers </SELECT> When the size is set to 1 small scrollbar appears… >>> More
MySQL Query Select using sub-select takes too long

as seen on Stack Overflow - Search for 'Stack Overflow'
I noticed something strange while executing a select from 2 tables: SELECT * FROM table_1 WHERE id IN ( SELECT id_element FROM table_2 WHERE column_2=3103); This query took approximatively 242 seconds. But when I executed the subquery SELECT id_element FROM table_2 WHERE column_2=3103 it… >>> More
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)

as seen on SQL Authority - Search for 'SQL Authority'
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to… >>> More
Nesting Linq-to-Objects query within Linq-to-Entities query –what is happening under the covers?

as seen on Programmers - Search for 'Programmers'
var numbers = new int[] { 1, 2, 3, 4, 5 }; var contacts = from c in context.Contacts where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault() select c; foreach (var item in contacts) Console.WriteLine(item.ContactID); Linq-to-Entities… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More

Related posts about parent

Planning Database as a Service Implementation Project

as seen on Oracle Blogs - Search for 'Oracle Blogs'
People, process and planning are the three key elements to success in a private cloud journey. Some common questions i hear from field/customers often relates to tasks involved in setting up Database-as-a-Service(DBaaS) using Oracle Enterprise Manager 12c from scratch and how these tasks are mapped… >>> More
Better way to "find parent" and if statements

as seen on Stack Overflow - Search for 'Stack Overflow'
I can't figure out why this isn't working: $(document).ready(function() { if ($('.checkarea.unchecked').length) { $(this).parent().parent().parent().parent().parent().parent().parent().removeClass('checked').addClass('unchecked'); } else { $(this).parent().parent().parent().parent()… >>> More
PHP and Classes: access to parent's public property within the parent class

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, here is what my code looks like i have two forms: class Form_1 extends Form_Abstract { public $iId = 1; } class Form_2 extends Form_1 { public $iId = 2; } i expect the code behave like this: $oForm = new Form_2; echo $oForm->getId(); // it returns '2' echo $oForm->getParentId();… >>> More
Parent Objects

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Support for Parent Objects was added in Solaris 11 Update 1. The following material is adapted from the PSARC arc case, and the Solaris Linker and Libraries Manual. A "plugin" is a shared object, usually loaded via dlopen(), that is used by a program in order to allow the end user to add functionality to… >>> More
Parse and transform XML with missing elements into table structure

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to parse an XML file. A simplified version of it looks like this: x <- '<grandparent><parent><child1>ABC123</child1><child2>1381956044</child2></parent><parent><child2>1397527137</child2></parent><parent><child3>4675</child3></parent><parent><child1>DEF456</child1><child3>3735</child3></parent><parent><child1/><child3>3735</child3></parent></grandparent>' library(XML) xmlRoot(xmlTreeParse(x)) ##… >>> More