REPOST: Re: help needed with a SQL query

From: Sunil Pant <spant_at_eline.com>
Date: Thu, 24 Jan 2002 20:42:03 GMT
Message-ID: <8$--$%%%_$_--%%-_$@news.noc.cabal.int>

Sorry for the mistake in earlier posting. I've a query that returns the following result set:

title             video        dvd      vod
monster     NULL      50493   NULL
monster    48359       NULL   NULL

I want to display the above query as follows:
title             video        dvd      vod
monster     48359      50493   NULL

monster

Any ideas would be appreciated.
Thanks,
SP

WAS CANCELLED BY =======: From: "Sunil Pant" <spant_at_eline.com> Control: cancel <vk_38.221$497.8376_at_sea-read.news.verio.net> Subject: cmsg cancel <vk_38.221$497.8376_at_sea-read.news.verio.net> Date: Mon, 28 Jan 2002 02:00:20 GMT Message-ID: <cancel.vk_38.221$497.8376_at_sea-read.news.verio.net> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!uni-erlangen.de!newsfeeds.belnet.be!news.belnet.be!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!amsnews01.chello.com!news-x2.support.nl!news2.euro.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40724494

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 14:42:03 CST