Hi everybody,

I have a complex (and wrong) select statement that I tried yesterday at home (where I have an empty database with the same structure) and this query produced an error.

SELECT P.PersonID, P.FirstName, P.MiddleName, P.LastName, P.Gender, 
P.DOB, 
( select top 1  Address1 from people where personid=P.father ) as FAddress ,  
  ( select top 1  Address1 from people where personid=P.mother ) as MAddress ,
(select  case ( select top 1  CellPhone from people where personid=P.father) when '' then '-' else 
( select top 1  CellPhone from people where personid=P.father) end) as FCellPhone , 
(select case ( select top 1 CellPhone from people where personid=P.mother ) when ''  
then '-' else ( select top 1 CellPhone from people where personid=P.mother ) end) as MCellPhone

, etc.

I tried this select again here and it worked just fine.

The only difference that I don't have data at home.

In any case, the select statement is wrong, so I would be changing it... But just curiosity sake why didn't it work without data?

Thanks again.