Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rick C. Hodgin
  Where is Rick C. Hodgin?
 Indianapolis
 Indiana - United States
 Rick C. Hodgin
 To: Carlos Lima
  Where is Carlos Lima?
 Mindelo
 Cape Verde
 Carlos Lima
 Tags
Subject: RE: select returning null values
Thread ID: 373821 Message ID: 373825 # Views: 50 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, March 27, 2013 2:48:29 PM         
   


> ERROR: Field descricao does nott accept null values
>
> Why this select return null values?
>
> SELECT Servicos.designacao as descricao, Servicos.codigo;
> FROM Servicos ;
> RIGHT JOIN TipoServicos ON Servicos.tipo_servico==TipoServicos.codigo ;
> and TipoServicos.exame_complementar == "S" ;
> and TipoServicos.requisicao == "S" ;
> INTO CURSOR DD
> BROW


http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg

Look at the second image down on right. You'll see that it includes a filter to remove the .NULL. values when they are not desired.

Best regards,
Rick C. Hodgin

ENTIRE THREAD

select returning null values Posted by Carlos Lima @ 3/27/2013 1:13:34 PM
RE: select returning null values Posted by Borislav Borissov @ 3/27/2013 2:06:10 PM
RE: select returning null values Posted by Rick Hodgin @ 3/27/2013 2:48:29 PM
RE: select returning null values Posted by Paul Gibson @ 3/27/2013 3:22:22 PM
RE: select returning null values Posted by Jun Tangunan @ 3/27/2013 11:47:46 PM