HMMM! Strange how a simple question aroused such smallmindedness!

Psychology is simple!

landonkelsey wrote:
--
Message posted via http://www.dbmonster.com

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?



landonkelsey wrote:
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....heory/200708/1

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:
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....heory/200708/1

Bob Badour wrote:
The second sentence that mentioned candidates contradicted the first but
as a spec, I thought the first one was precise enough: "A telephone call
is uniquely identified by telephone number and time of call."

That made it seem clear to me that cell phones aren't involved and even
if they were, I thought they could move between transmitters during the
call. Anyway, without the second sentence, seems like it isn't BCNF as
several others mentioned, with the second sentence, seems like it isn't
2NF as Bob B clarified. Once normalized, I would have thought any
question involving location would have to do with the application, not
normal form.

p

I assume you mean "other than the two who already plonked you" ?

Plonk!

landonkelsey via DBMonster.com wrote:

I got it! I got it!

You fell off your skateboards and medications!

Well! have fun texting each other down at the arcade!

Bob Badour wrote:
--
Message posted via http://www.dbmonster.com

Larry! I am worried! who is this guy? Under an assumed name?

(1) Dr Lecter (not hopkins)
(2) faculty...our prof in the course we are taking "MS Access"
(3) mafia member
(4) some other psycho!
(5) Iranian

It is dark outside and I just heard a car door close outside!

There a dog is barking!

I'm calling for mommy!!!!


landonkelsey wrote:
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....heory/200708/1

On 28 Aug, 00:42, "landonkelsey via DBMonster.com" <u36972@uwe> wrote:
Is "does not work" considered to be an adequate description of a
problem in your organization / place of study?

Perhaps the answer is that your query is not valid SQL (because the
correct syntax is FULL OUTER JOIN ... ON).
Perhaps the answer is that you omitted to declare any keys for either
table.

--
David Portas

somebody tried the SQL on Oracle and it worked!

It worked on MS SQL Server!

the left and right outer joins worked...yes I fixed the where->on

what kind of sick forum did I get myself into!

a bunch of arrogant people with NO scientific knowledge some disturbed by my
simple little normalization problem

I've always found arrogance and talent to be mutually exclusive!

I am out of this forum!

The world will hit you like a freight train once you get out of that little
college into the real world.

THAT IS IT! You are there thinking you should have gone to Stanford or that
other place!

Let go of that failure and learn all you can!

David Portas wrote:
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....heory/200708/1