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....bases/200708/1

It doesn't seem MS Access allows a FULL OUTER JOIN, only INNER, LEFT
OUTER and RIGHT OUTER. Apparently many dbs don't implement it, due to
its limited use. If mysql does allow it, maybe the syntax needs to be:
select * from girls full outer join boys ON girls.city = boys.city;

boys
name city
john chicago
bob

girls
name city
mary chicago
sue

join_boys_girls
boy.name city girl.name
john chicago mary
bob
sue