MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Union and NULL
Posted by: Ramalingam Chelliah
Date: August 10, 2004 06:17AM

Hi,
I tried that ...and getting it as you expectedit to be...

I presume that You have Parent,Child Fields Parent may be NULL

If Parent is Not null You add Both to result set
If Parent is NULL You add Child as Parent, Null as Child to result set

Have I assumed in the right way ?
I am not getting '0' here...

Regards,
Ram.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Union and NULL
Peter Heiberg
August 10, 2004 03:26AM
Re: Union and NULL
Ramalingam Chelliah
August 10, 2004 06:17AM
Re: Union and NULL
Peter Heiberg
August 10, 2004 07:53AM
Re: Union and NULL
Peter Heiberg
August 10, 2004 08:29AM
Re: Union and NULL
Ramalingam Chelliah
August 11, 2004 04:20AM
Re: Union and NULL
Ramalingam Chelliah
August 11, 2004 04:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.