Re: normalization review

From: landonkelsey via DBMonster.com <u36972_at_uwe>
Date: Mon, 27 Aug 2007 23:42:53 GMT
Message-ID: <7757e339d8f28_at_uwe>

lets see what you boys know!

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');

If needed, I can go into insert and create for you!

BTW left and right work OK!

landonkelsey wrote:
>I figured it out!
>
>I unknowingly joined a forum at "Mad Comic Book"
>
>I give free psycho advice! Tell me : where are the true scientists?
>
>>HMMM! Strange how a simple question aroused such smallmindedness!
>>
>[quoted text clipped - 5 lines]
>>>>Larry Coon
>>>>University of California

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

Received on Tue Aug 28 2007 - 01:42:53 CEST