-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Bhau
Message 5 in Discussion
HI,
I am not sure whether this address your question. But I feel we dont require
the union as it slashes the performance.....
try to use this query.... let me know if you have any problem..
select p1.pid, case when cname is null then pname
else cname
end As name from p p1 left join c c1 on p1.pid = c1.pid order by
1
Bhavesh Shah
[EMAIL PROTECTED]
>From: "BDOTNET" <[EMAIL PROTECTED]>
>Reply-To: "BDOTNET" <[EMAIL PROTECTED]>
>To: "BDOTNET" <[EMAIL PROTECTED]>
>Subject: Re: Sql query parent child join
>Date: Wed, 8 Sep 2004 21:44:13 -0700
>
_________________________________________________________________
1 Paisa No Reserve Auctions.
http://ads2.baazee.com/cgi-bin/banners/redirect.pl?id=2553 T-Shirts, Shirts,
Kurtas, Apparels.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
