Re: SQL consundrum du jour...

[dr2@xxxxxxxx]

yes we were going down that trail, but then, how would one handle that
condition??  slsupd is a subset of master, yes, but there's got to be a
way to do this with a subsetted updates/changes file... 

On 2021-03-19 16:29, Therrien, Paul via MIDRANGE-L wrote:

> no hit on customer in slsupd ; so msales would be null
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of dr2@xxxxxxxx
> Sent: Friday, March 19, 2021 4:25 PM
> To: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> Subject: SQL consundrum du jour...
>
> Greetings... 
>
> I've used this exact same SQL in other updates just fine...all I sub'd this time was the file(s) and field(s)...yeah, famous last words...  But this time I'm getting a "Null values not allowed in column or variable MSALES. "  error...  Any idea what I'm not seeing? 
>
> msales and rep are saleman numbers, and mcusno and cust are customer numbers...  
>
> update drtemp.master                                            
> set                                                            
> drtemp.master.msales =                                       
> (select                                                         
> rep     from                                                
> drtemp.slsupd                                        
> where                                            
> (drtemp.master.mcusno = drtemp.slsupd.cust   )    
> )      
>
> Thanks...
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com