Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Paul Gibson
  Where is Paul Gibson?
 Glasgow
 United Kingdom
 Paul Gibson
 To: Rick C. Hodgin
  Where is Rick C. Hodgin?
 Indianapolis
 Indiana - United States
 Rick C. Hodgin
 Tags
Subject: RE: select returning null values
Thread ID: 373821 Message ID: 373829 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, March 27, 2013 3:22:22 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.
>

Good image, simplifies and summarises the possibilities very succinctly. Thanks for linking.

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