MySQL Forums
Forum List  »  Newbie

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

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...


Options: ReplyQuote

Written By
August 10, 2004 03:26AM
Re: Union and NULL
August 10, 2004 06:17AM
August 10, 2004 07:53AM
August 10, 2004 08:29AM
August 11, 2004 04:20AM
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.