mysql full outer join

why doesn't the following work?

mysql> select * from girls full outer join boys where girls.city = boys.city;

where :

drop table girls;
drop table boys;
create table girls (name varchar(12), city varchar(12));
create table boys (name varchar(12), city varchar(12));
insert into girls values('Mary', 'Boston');
insert into girls values('Nancy', null);
insert into girls values('Susan', 'Chicago');
insert into girls values('Betty', 'Chicago');
insert into girls values('Anne', 'Denver');
insert into boys values('John', 'Boston');
insert into boys values('Henry', 'Boston');
insert into boys values('George', null);
insert into boys values('Sam', 'Chicago');
insert into boys values('James', 'Dallas');

BTW left and right work OK! (replace full with left or right)

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/databases/200708/1

.

Relevant Pages

  • Re: Boys education funds unveiled to reduce gender gap
    ... Then why can't you show me how sports programs for girls and boys are ... > girls are getting equal funding, of necessity, more boys will not have ... With regards to sports programs, ...
    (soc.men)
  • Re: Boys education funds unveiled to reduce gender gap
    ... There is no suble discrimination against boys by women and girls ... but only with TOTALLY EQUAL FUNDING. ... > No one has ever been able to demonstrate that the fact that more boys> engage in sports means the girls get shortchanged in the classroom. ...
    (soc.men)
  • Re: Are men discriminated against as child-minders?
    ... was not really a pedophile, but was simply acting out of his curiosity. ... the house my aunt and uncle had rented out to a "nice ... Plus, boys mature slower than girls of that age, ...
    (soc.men)
  • Re: Boys education funds unveiled to reduce gender gap
    ... There is no suble discrimination against boys by women and girls ... The "proof" that was used for girls is apparently not good enough to be ... >>> Your observations are not relevant to equal funding. ... single person plan, two-person, or family plan, depending on their ...
    (soc.men)
  • Re: Boys education funds unveiled to reduce gender gap
    ... There is no suble discrimination against boys by women and girls ... >>> Equal FUNDING is my only concern regardless of how they spend it. ... >> engage in sports means the girls get shortchanged in the classroom. ...
    (soc.men)