Re: This is not trivia pursuit....

[John Ferguson <jferguson@INETNOW.NET>]

I thought the whole purpose of this group was to help each other out. Not everyone can be a smart as you think you are. It would have served everyone
better if you just pointed out the mistake instead of making a joke about it.

If you remember back to when you started coding, I'm sure you didn't have all of the answers. Think about that next you consider any question stupid or
people as clueless.

John

Sam Spritzer wrote:

> Don't you just love it when clueless users make a request that, in their world, makes perfect sense to them within the realm of their logic and common
> sense.....hence, take a look at the following.
>
> I am trying to update a varchar(30) column from one table with a varchar(30) column from another table. I have already tested both columns for null
> values....and there aren't any. Can any of you shed any light in this?
>
>             *********************************************
> SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> Connected to:
> Oracle7 Server Release 7.3.4.3.0 - Production
> With the distributed, replication, parallel query and Spatial Data options
> PL/SQL Release 2.3.4.3.0 - Production
>
> SQL> update ps_employment a
>    2 set a.business_title = (select b.jobtitle
>    3 from ps_employees b
>    4 where a.emplid = b.emplid);
> from ps_employees b
>      *
> ERROR at line 3:
> ORA-01407: cannot update mandatory (NOT NULL) column to NULL
>             ****************************************
>
> SQRly yours,
> Sam